Dataset statistics
| Number of variables | 32 |
|---|---|
| Number of observations | 903653 |
| Missing cells | 6389257 |
| Missing cells (%) | 22.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.2 GiB |
| Average record size in memory | 1.4 KiB |
Variable types
| Categorical | 11 |
|---|---|
| DateTime | 1 |
| Unsupported | 1 |
| Text | 10 |
| Numeric | 7 |
| Boolean | 1 |
| Path | 1 |
adContent is highly overall correlated with campaign and 4 other fields | High correlation |
adwordsClickInfo.adNetworkType is highly overall correlated with channelGrouping and 1 other fields | High correlation |
adwordsClickInfo.page is highly overall correlated with channelGrouping and 1 other fields | High correlation |
adwordsClickInfo.slot is highly overall correlated with channelGrouping and 1 other fields | High correlation |
campaign is highly overall correlated with adContent and 2 other fields | High correlation |
channelGrouping is highly overall correlated with adContent and 5 other fields | High correlation |
continent is highly overall correlated with subContinent | High correlation |
deviceCategory is highly overall correlated with isMobile and 1 other fields | High correlation |
hits is highly overall correlated with pageviews | High correlation |
isMobile is highly overall correlated with deviceCategory and 1 other fields | High correlation |
medium is highly overall correlated with adContent and 5 other fields | High correlation |
operatingSystem is highly overall correlated with deviceCategory and 1 other fields | High correlation |
pageviews is highly overall correlated with hits | High correlation |
subContinent is highly overall correlated with continent | High correlation |
visitId is highly overall correlated with adContent and 1 other fields | High correlation |
visitStartTime is highly overall correlated with adContent and 1 other fields | High correlation |
campaign is highly imbalanced (90.3%) | Imbalance |
adwordsClickInfo.slot is highly imbalanced (83.9%) | Imbalance |
adwordsClickInfo.adNetworkType is highly imbalanced (99.6%) | Imbalance |
conversion is highly imbalanced (90.2%) | Imbalance |
transactionRevenue has 892138 (98.7%) missing values | Missing |
keyword has 502929 (55.7%) missing values | Missing |
referralPath has 572712 (63.4%) missing values | Missing |
adwordsClickInfo.page has 882193 (97.6%) missing values | Missing |
adwordsClickInfo.slot has 882193 (97.6%) missing values | Missing |
adwordsClickInfo.gclId has 882092 (97.6%) missing values | Missing |
adwordsClickInfo.adNetworkType has 882193 (97.6%) missing values | Missing |
adContent has 892707 (98.8%) missing values | Missing |
transactionRevenue is highly skewed (γ1 = 25.7227026) | Skewed |
adwordsClickInfo.page is highly skewed (γ1 = 40.17090183) | Skewed |
fullVisitorId is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2024-02-20 12:38:37.555919 |
|---|---|
| Analysis finished | 2024-02-20 12:40:59.337155 |
| Duration | 2 minutes and 21.78 seconds |
| Software version | ydata-profiling vv4.6.4 |
| Download configuration | config.json |
channelGrouping
Categorical
HIGH CORRELATION 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 57.6 MiB |
| Organic Search | |
|---|---|
| Social | |
| Direct | |
| Referral | |
| Paid Search | 25326 |
| Other values (3) | 22785 |
Length
| Max length | 14 |
|---|---|
| Median length | 11 |
| Mean length | 9.8297754 |
| Min length | 6 |
Characters and Unicode
| Total characters | 8882706 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Organic Search |
|---|---|
| 2nd row | Organic Search |
| 3rd row | Organic Search |
| 4th row | Organic Search |
| 5th row | Organic Search |
Common Values
| Value | Count | Frequency (%) |
| Organic Search | 381561 | |
| Social | 226117 | |
| Direct | 143026 | 15.8% |
| Referral | 104838 | 11.6% |
| Paid Search | 25326 | 2.8% |
| Affiliates | 16403 | 1.8% |
| Display | 6262 | 0.7% |
| (Other) | 120 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| search | 406887 | |
| organic | 381561 | |
| social | 226117 | |
| direct | 143026 | 10.9% |
| referral | 104838 | 8.0% |
| paid | 25326 | 1.9% |
| affiliates | 16403 | 1.3% |
| display | 6262 | 0.5% |
| other | 120 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1167394 | |
| c | 1157591 | |
| r | 1141270 | |
| i | 815098 | |
| e | 776112 | |
| S | 633004 | 7.1% |
| h | 407007 | 4.6% |
| 406887 | 4.6% | |
| O | 381681 | 4.3% |
| g | 381561 | 4.3% |
| Other values (15) | 1615101 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7165039 | |
| Uppercase Letter | 1310540 | 14.8% |
| Space Separator | 406887 | 4.6% |
| Open Punctuation | 120 | < 0.1% |
| Close Punctuation | 120 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 1167394 | |
| c | 1157591 | |
| r | 1141270 | |
| i | 815098 | |
| e | 776112 | |
| h | 407007 | 5.7% |
| g | 381561 | 5.3% |
| n | 381561 | 5.3% |
| l | 353620 | 4.9% |
| o | 226117 | 3.2% |
| Other values (6) | 357708 | 5.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 633004 | |
| O | 381681 | |
| D | 149288 | 11.4% |
| R | 104838 | 8.0% |
| P | 25326 | 1.9% |
| A | 16403 | 1.3% |
Space Separator
| Value | Count | Frequency (%) |
| 406887 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 120 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 120 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8475579 | |
| Common | 407127 | 4.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 1167394 | |
| c | 1157591 | |
| r | 1141270 | |
| i | 815098 | |
| e | 776112 | |
| S | 633004 | |
| h | 407007 | 4.8% |
| O | 381681 | 4.5% |
| g | 381561 | 4.5% |
| n | 381561 | 4.5% |
| Other values (12) | 1233300 |
Common
| Value | Count | Frequency (%) |
| 406887 | ||
| ( | 120 | < 0.1% |
| ) | 120 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8882706 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 1167394 | |
| c | 1157591 | |
| r | 1141270 | |
| i | 815098 | |
| e | 776112 | |
| S | 633004 | 7.1% |
| h | 407007 | 4.6% |
| 406887 | 4.6% | |
| O | 381681 | 4.3% |
| g | 381561 | 4.3% |
| Other values (15) | 1615101 |
date
Date
| Distinct | 366 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
| Minimum | 1970-01-01 00:00:00.020160 |
|---|---|
| Maximum | 1970-01-01 00:00:00.020170 |
fullVisitorId
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 38.7 MiB |
sessionId
Text
| Distinct | 902755 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 74.9 MiB |
Length
| Max length | 31 |
|---|---|
| Median length | 30 |
| Mean length | 29.878958 |
| Min length | 24 |
Characters and Unicode
| Total characters | 27000210 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 901857 ? |
|---|---|
| Unique (%) | 99.8% |
Sample
| 1st row | 1131660440785968503_1472830385 |
|---|---|
| 2nd row | 377306020877927890_1472880147 |
| 3rd row | 3895546263509774583_1472865386 |
| 4th row | 4763447161404445595_1472881213 |
| 5th row | 27294437909732085_1472822600 |
| Value | Count | Frequency (%) |
| 14108533830165900_1482391162 | 2 | < 0.1% |
| 7328657227470299189_1488700723 | 2 | < 0.1% |
| 2896409751679637889_1497249098 | 2 | < 0.1% |
| 1920231893487967243_1494224540 | 2 | < 0.1% |
| 9328692348677910181_1490338007 | 2 | < 0.1% |
| 2936634930290678437_1486195062 | 2 | < 0.1% |
| 3332070148916030858_1488700627 | 2 | < 0.1% |
| 31144590393948452_1499929196 | 2 | < 0.1% |
| 4203774291422453000_1499065071 | 2 | < 0.1% |
| 0461869076077289632_1495090739 | 2 | < 0.1% |
| Other values (902745) | 903633 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 3250435 | |
| 4 | 3181333 | |
| 7 | 2672658 | |
| 8 | 2612708 | |
| 9 | 2597893 | |
| 0 | 2417472 | |
| 5 | 2378325 | |
| 6 | 2333813 | |
| 3 | 2329535 | |
| 2 | 2322385 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 26096557 | |
| Connector Punctuation | 903653 | 3.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 3250435 | |
| 4 | 3181333 | |
| 7 | 2672658 | |
| 8 | 2612708 | |
| 9 | 2597893 | |
| 0 | 2417472 | |
| 5 | 2378325 | |
| 6 | 2333813 | |
| 3 | 2329535 | |
| 2 | 2322385 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 903653 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 27000210 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 3250435 | |
| 4 | 3181333 | |
| 7 | 2672658 | |
| 8 | 2612708 | |
| 9 | 2597893 | |
| 0 | 2417472 | |
| 5 | 2378325 | |
| 6 | 2333813 | |
| 3 | 2329535 | |
| 2 | 2322385 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 27000210 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 3250435 | |
| 4 | 3181333 | |
| 7 | 2672658 | |
| 8 | 2612708 | |
| 9 | 2597893 | |
| 0 | 2417472 | |
| 5 | 2378325 | |
| 6 | 2333813 | |
| 3 | 2329535 | |
| 2 | 2322385 |
visitId
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 886303 |
|---|---|
| Distinct (%) | 98.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4850073 × 109 |
| Minimum | 1.4700348 × 109 |
|---|---|
| Maximum | 1.5016572 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 1.4700348 × 109 |
|---|---|
| 5-th percentile | 1.4716204 × 109 |
| Q1 | 1.4775612 × 109 |
| median | 1.4839487 × 109 |
| Q3 | 1.4927588 × 109 |
| 95-th percentile | 1.4999783 × 109 |
| Maximum | 1.5016572 × 109 |
| Range | 31622381 |
| Interquartile range (IQR) | 15197593 |
Descriptive statistics
| Standard deviation | 9022123.6 |
|---|---|
| Coefficient of variation (CV) | 0.0060754743 |
| Kurtosis | -1.1657356 |
| Mean | 1.4850073 × 109 |
| Median Absolute Deviation (MAD) | 7323946 |
| Skewness | 0.19405148 |
| Sum | 1.3419313 × 1015 |
| Variance | 8.1398713 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1493146175 | 8 | < 0.1% |
| 1478345904 | 6 | < 0.1% |
| 1481369525 | 6 | < 0.1% |
| 1484649802 | 6 | < 0.1% |
| 1500856602 | 5 | < 0.1% |
| 1494374199 | 5 | < 0.1% |
| 1495031359 | 5 | < 0.1% |
| 1488904421 | 4 | < 0.1% |
| 1481365730 | 4 | < 0.1% |
| 1488190236 | 4 | < 0.1% |
| Other values (886293) | 903600 |
| Value | Count | Frequency (%) |
| 1470034812 | 1 | |
| 1470035066 | 1 | |
| 1470035081 | 1 | |
| 1470035161 | 1 | |
| 1470035170 | 1 | |
| 1470035292 | 1 | |
| 1470035429 | 1 | |
| 1470035457 | 1 | |
| 1470035501 | 1 | |
| 1470035521 | 1 |
| Value | Count | Frequency (%) |
| 1501657193 | 1 | |
| 1501657190 | 1 | |
| 1501657186 | 1 | |
| 1501657166 | 1 | |
| 1501657161 | 1 | |
| 1501657013 | 1 | |
| 1501656998 | 1 | |
| 1501656981 | 1 | |
| 1501656976 | 1 | |
| 1501656970 | 1 |
visitNumber
Real number (ℝ)
| Distinct | 384 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.264897 |
| Minimum | 1 |
|---|---|
| Maximum | 395 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 5 |
| Maximum | 395 |
| Range | 394 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 9.2837345 |
|---|---|
| Coefficient of variation (CV) | 4.0989654 |
| Kurtosis | 517.3079 |
| Mean | 2.264897 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 19.998064 |
| Sum | 2046681 |
| Variance | 86.187726 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 703060 | |
| 2 | 92548 | 10.2% |
| 3 | 35843 | 4.0% |
| 4 | 19157 | 2.1% |
| 5 | 11615 | 1.3% |
| 6 | 7677 | 0.8% |
| 7 | 5413 | 0.6% |
| 8 | 4031 | 0.4% |
| 9 | 3084 | 0.3% |
| 10 | 2415 | 0.3% |
| Other values (374) | 18810 | 2.1% |
| Value | Count | Frequency (%) |
| 1 | 703060 | |
| 2 | 92548 | 10.2% |
| 3 | 35843 | 4.0% |
| 4 | 19157 | 2.1% |
| 5 | 11615 | 1.3% |
| 6 | 7677 | 0.8% |
| 7 | 5413 | 0.6% |
| 8 | 4031 | 0.4% |
| 9 | 3084 | 0.3% |
| 10 | 2415 | 0.3% |
| Value | Count | Frequency (%) |
| 395 | 1 | |
| 394 | 1 | |
| 393 | 1 | |
| 391 | 1 | |
| 390 | 1 | |
| 389 | 1 | |
| 388 | 1 | |
| 387 | 1 | |
| 386 | 1 | |
| 385 | 1 |
visitStartTime
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 887159 |
|---|---|
| Distinct (%) | 98.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4850073 × 109 |
| Minimum | 1.4700348 × 109 |
|---|---|
| Maximum | 1.5016572 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 1.4700348 × 109 |
|---|---|
| 5-th percentile | 1.4716204 × 109 |
| Q1 | 1.4775612 × 109 |
| median | 1.4839489 × 109 |
| Q3 | 1.4927588 × 109 |
| 95-th percentile | 1.4999783 × 109 |
| Maximum | 1.5016572 × 109 |
| Range | 31622381 |
| Interquartile range (IQR) | 15197593 |
Descriptive statistics
| Standard deviation | 9022123.7 |
|---|---|
| Coefficient of variation (CV) | 0.0060754743 |
| Kurtosis | -1.1657356 |
| Mean | 1.4850073 × 109 |
| Median Absolute Deviation (MAD) | 7323976 |
| Skewness | 0.19405153 |
| Sum | 1.3419313 × 1015 |
| Variance | 8.1398716 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1493146175 | 8 | < 0.1% |
| 1478345904 | 6 | < 0.1% |
| 1484649802 | 6 | < 0.1% |
| 1481369525 | 6 | < 0.1% |
| 1495031359 | 5 | < 0.1% |
| 1500856602 | 5 | < 0.1% |
| 1494374199 | 5 | < 0.1% |
| 1490274633 | 4 | < 0.1% |
| 1494590623 | 4 | < 0.1% |
| 1490264449 | 4 | < 0.1% |
| Other values (887149) | 903600 |
| Value | Count | Frequency (%) |
| 1470034812 | 1 | |
| 1470035066 | 1 | |
| 1470035081 | 1 | |
| 1470035161 | 1 | |
| 1470035170 | 1 | |
| 1470035292 | 1 | |
| 1470035429 | 1 | |
| 1470035457 | 1 | |
| 1470035501 | 1 | |
| 1470035521 | 1 |
| Value | Count | Frequency (%) |
| 1501657193 | 1 | |
| 1501657190 | 1 | |
| 1501657186 | 1 | |
| 1501657166 | 1 | |
| 1501657161 | 1 | |
| 1501657013 | 1 | |
| 1501656998 | 1 | |
| 1501656981 | 1 | |
| 1501656976 | 1 | |
| 1501656970 | 1 |
continent
Categorical
HIGH CORRELATION 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 54.7 MiB |
| Americas | |
|---|---|
| Asia | |
| Europe | |
| Oceania | 15054 |
| Africa | 14745 |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 6.5232274 |
| Min length | 4 |
Characters and Unicode
| Total characters | 5894734 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Asia |
|---|---|
| 2nd row | Oceania |
| 3rd row | Europe |
| 4th row | Asia |
| 5th row | Europe |
Common Values
| Value | Count | Frequency (%) |
| Americas | 450377 | |
| Asia | 223698 | |
| Europe | 198311 | |
| Oceania | 15054 | 1.7% |
| Africa | 14745 | 1.6% |
| (not set) | 1468 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| americas | 450377 | |
| asia | 223698 | |
| europe | 198311 | |
| oceania | 15054 | 1.7% |
| africa | 14745 | 1.6% |
| not | 1468 | 0.2% |
| set | 1468 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 718928 | |
| i | 703874 | |
| A | 688820 | |
| s | 675543 | |
| e | 665210 | |
| r | 663433 | |
| c | 480176 | |
| m | 450377 | |
| o | 199779 | 3.4% |
| p | 198311 | 3.4% |
| Other values (9) | 450283 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4988145 | |
| Uppercase Letter | 902185 | 15.3% |
| Open Punctuation | 1468 | < 0.1% |
| Space Separator | 1468 | < 0.1% |
| Close Punctuation | 1468 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 718928 | |
| i | 703874 | |
| s | 675543 | |
| e | 665210 | |
| r | 663433 | |
| c | 480176 | |
| m | 450377 | |
| o | 199779 | 4.0% |
| p | 198311 | 4.0% |
| u | 198311 | 4.0% |
| Other values (3) | 34203 | 0.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 688820 | |
| E | 198311 | 22.0% |
| O | 15054 | 1.7% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1468 |
Space Separator
| Value | Count | Frequency (%) |
| 1468 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1468 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5890330 | |
| Common | 4404 | 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 718928 | |
| i | 703874 | |
| A | 688820 | |
| s | 675543 | |
| e | 665210 | |
| r | 663433 | |
| c | 480176 | |
| m | 450377 | |
| o | 199779 | 3.4% |
| p | 198311 | 3.4% |
| Other values (6) | 445879 |
Common
| Value | Count | Frequency (%) |
| ( | 1468 | |
| 1468 | ||
| ) | 1468 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5894734 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 718928 | |
| i | 703874 | |
| A | 688820 | |
| s | 675543 | |
| e | 665210 | |
| r | 663433 | |
| c | 480176 | |
| m | 450377 | |
| o | 199779 | 3.4% |
| p | 198311 | 3.4% |
| Other values (9) | 450283 |
subContinent
Categorical
HIGH CORRELATION 
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.7 MiB |
| Northern America | |
|---|---|
| Southeast Asia | |
| Southern Asia | |
| Western Europe | |
| Northern Europe | |
| Other values (18) |
Length
| Max length | 18 |
|---|---|
| Median length | 16 |
| Mean length | 14.621631 |
| Min length | 9 |
Characters and Unicode
| Total characters | 13212881 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Western Asia |
|---|---|
| 2nd row | Australasia |
| 3rd row | Southern Europe |
| 4th row | Southeast Asia |
| 5th row | Northern Europe |
Common Values
| Value | Count | Frequency (%) |
| Northern America | 390657 | |
| Southeast Asia | 77800 | 8.6% |
| Southern Asia | 59321 | 6.6% |
| Western Europe | 59114 | 6.5% |
| Northern Europe | 58168 | 6.4% |
| Eastern Asia | 46919 | 5.2% |
| Eastern Europe | 45249 | 5.0% |
| South America | 41731 | 4.6% |
| Western Asia | 38443 | 4.3% |
| Southern Europe | 35780 | 4.0% |
| Other values (13) | 50471 | 5.6% |
Length
| Value | Count | Frequency (%) |
| northern | 456508 | |
| america | 447971 | |
| asia | 223698 | |
| europe | 198311 | |
| western | 100130 | 5.6% |
| southern | 97270 | 5.4% |
| eastern | 94095 | 5.3% |
| southeast | 77800 | 4.3% |
| south | 41731 | 2.3% |
| central | 16798 | 0.9% |
| Other values (10) | 35589 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 1899690 | |
| e | 1593577 | |
| t | 979961 | 7.4% |
| a | 924840 | 7.0% |
| 886248 | 6.7% | |
| o | 873223 | 6.6% |
| n | 768946 | 5.8% |
| i | 704377 | 5.3% |
| A | 701307 | 5.3% |
| h | 673309 | 5.1% |
| Other values (21) | 3207403 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 10536732 | |
| Uppercase Letter | 1786965 | 13.5% |
| Space Separator | 886248 | 6.7% |
| Open Punctuation | 1468 | < 0.1% |
| Close Punctuation | 1468 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 1899690 | |
| e | 1593577 | |
| t | 979961 | |
| a | 924840 | |
| o | 873223 | |
| n | 768946 | |
| i | 704377 | 6.7% |
| h | 673309 | 6.4% |
| s | 527138 | 5.0% |
| c | 462771 | 4.4% |
| Other values (9) | 1128900 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 701307 | |
| N | 456508 | |
| E | 292406 | |
| S | 216801 | 12.1% |
| W | 100130 | 5.6% |
| C | 19204 | 1.1% |
| M | 529 | < 0.1% |
| R | 55 | < 0.1% |
| P | 25 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 886248 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1468 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1468 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12323697 | |
| Common | 889184 | 6.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 1899690 | |
| e | 1593577 | |
| t | 979961 | 8.0% |
| a | 924840 | 7.5% |
| o | 873223 | 7.1% |
| n | 768946 | 6.2% |
| i | 704377 | 5.7% |
| A | 701307 | 5.7% |
| h | 673309 | 5.5% |
| s | 527138 | 4.3% |
| Other values (18) | 2677329 |
Common
| Value | Count | Frequency (%) |
| 886248 | ||
| ( | 1468 | 0.2% |
| ) | 1468 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 13212881 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 1899690 | |
| e | 1593577 | |
| t | 979961 | 7.4% |
| a | 924840 | 7.0% |
| 886248 | 6.7% | |
| o | 873223 | 6.6% |
| n | 768946 | 5.8% |
| i | 704377 | 5.3% |
| A | 701307 | 5.3% |
| h | 673309 | 5.1% |
| Other values (21) | 3207403 |
country
Text
| Distinct | 222 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 57.5 MiB |
Length
| Max length | 24 |
|---|---|
| Median length | 22 |
| Mean length | 9.7230386 |
| Min length | 4 |
Characters and Unicode
| Total characters | 8786253 |
|---|---|
| Distinct characters | 63 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 10 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Turkey |
|---|---|
| 2nd row | Australia |
| 3rd row | Spain |
| 4th row | Indonesia |
| 5th row | United Kingdom |
| Value | Count | Frequency (%) |
| united | 405281 | |
| states | 364744 | |
| india | 51140 | 3.8% |
| kingdom | 37393 | 2.8% |
| canada | 25869 | 1.9% |
| vietnam | 24598 | 1.8% |
| turkey | 20522 | 1.5% |
| thailand | 20123 | 1.5% |
| germany | 19980 | 1.5% |
| brazil | 19783 | 1.5% |
| Other values (252) | 349718 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 1238439 | |
| e | 1021620 | |
| a | 965182 | |
| n | 792306 | |
| i | 766000 | |
| d | 601015 | 6.8% |
| s | 464391 | 5.3% |
| 435498 | 5.0% | |
| U | 411769 | 4.7% |
| S | 410463 | 4.7% |
| Other values (53) | 1679570 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7005686 | |
| Uppercase Letter | 1338417 | 15.2% |
| Space Separator | 435498 | 5.0% |
| Open Punctuation | 2510 | < 0.1% |
| Close Punctuation | 2510 | < 0.1% |
| Other Punctuation | 1195 | < 0.1% |
| Final Punctuation | 320 | < 0.1% |
| Dash Punctuation | 117 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 1238439 | |
| e | 1021620 | |
| a | 965182 | |
| n | 792306 | |
| i | 766000 | |
| d | 601015 | |
| s | 464391 | 6.6% |
| r | 198000 | 2.8% |
| l | 151162 | 2.2% |
| o | 146869 | 2.1% |
| Other values (21) | 660702 |
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 411769 | |
| S | 410463 | |
| I | 85110 | 6.4% |
| T | 55494 | 4.1% |
| K | 50288 | 3.8% |
| C | 44495 | 3.3% |
| A | 32529 | 2.4% |
| P | 32433 | 2.4% |
| B | 31573 | 2.4% |
| V | 26788 | 2.0% |
| Other values (15) | 157475 | 11.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 1106 | |
| . | 89 | 7.4% |
Space Separator
| Value | Count | Frequency (%) |
| 435498 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 2510 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 2510 |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 320 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 117 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8344103 | |
| Common | 442150 | 5.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 1238439 | |
| e | 1021620 | |
| a | 965182 | |
| n | 792306 | |
| i | 766000 | |
| d | 601015 | |
| s | 464391 | 5.6% |
| U | 411769 | 4.9% |
| S | 410463 | 4.9% |
| r | 198000 | 2.4% |
| Other values (46) | 1474918 |
Common
| Value | Count | Frequency (%) |
| 435498 | ||
| ( | 2510 | 0.6% |
| ) | 2510 | 0.6% |
| & | 1106 | 0.3% |
| ’ | 320 | 0.1% |
| - | 117 | < 0.1% |
| . | 89 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8785433 | |
| None | 500 | < 0.1% |
| Punctuation | 320 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 1238439 | |
| e | 1021620 | |
| a | 965182 | |
| n | 792306 | |
| i | 766000 | |
| d | 601015 | 6.8% |
| s | 464391 | 5.3% |
| 435498 | 5.0% | |
| U | 411769 | 4.7% |
| S | 410463 | 4.7% |
| Other values (46) | 1678750 |
None
| Value | Count | Frequency (%) |
| ô | 320 | |
| é | 147 | |
| ç | 30 | 6.0% |
| ã | 1 | 0.2% |
| í | 1 | 0.2% |
| Å | 1 | 0.2% |
Punctuation
| Value | Count | Frequency (%) |
| ’ | 320 |
region
Text
| Distinct | 376 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 66.9 MiB |
Length
| Max length | 33 |
|---|---|
| Median length | 29 |
| Mean length | 20.613868 |
| Min length | 4 |
Characters and Unicode
| Total characters | 18627784 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Izmir |
|---|---|
| 2nd row | not available in demo dataset |
| 3rd row | Community of Madrid |
| 4th row | not available in demo dataset |
| 5th row | not available in demo dataset |
| Value | Count | Frequency (%) |
| not | 536056 | |
| available | 508229 | |
| in | 508229 | |
| demo | 508229 | |
| dataset | 508229 | |
| california | 107501 | 3.4% |
| new | 33063 | 1.1% |
| set | 27827 | 0.9% |
| york | 26433 | 0.8% |
| of | 13607 | 0.4% |
| Other values (452) | 342152 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 3037450 | |
| 2215902 | ||
| e | 1709137 | |
| t | 1704294 | |
| i | 1434438 | |
| o | 1338634 | |
| n | 1327976 | |
| l | 1227746 | |
| d | 1063436 | 5.7% |
| s | 629109 | 3.4% |
| Other values (46) | 2939662 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 15832688 | |
| Space Separator | 2215902 | 11.9% |
| Uppercase Letter | 512694 | 2.8% |
| Close Punctuation | 27827 | 0.1% |
| Open Punctuation | 27827 | 0.1% |
| Dash Punctuation | 10582 | 0.1% |
| Other Punctuation | 264 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 3037450 | |
| e | 1709137 | |
| t | 1704294 | |
| i | 1434438 | |
| o | 1338634 | |
| n | 1327976 | |
| l | 1227746 | |
| d | 1063436 | 6.7% |
| s | 629109 | 4.0% |
| m | 532538 | 3.4% |
| Other values (16) | 1827930 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 145934 | |
| N | 43828 | 8.5% |
| M | 36782 | 7.2% |
| T | 35969 | 7.0% |
| Y | 26465 | 5.2% |
| D | 21969 | 4.3% |
| S | 21727 | 4.2% |
| I | 19813 | 3.9% |
| B | 19351 | 3.8% |
| H | 17118 | 3.3% |
| Other values (15) | 123738 |
Space Separator
| Value | Count | Frequency (%) |
| 2215902 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 27827 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 27827 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 10582 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 264 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 16345382 | |
| Common | 2282402 | 12.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 3037450 | |
| e | 1709137 | |
| t | 1704294 | |
| i | 1434438 | |
| o | 1338634 | |
| n | 1327976 | |
| l | 1227746 | |
| d | 1063436 | 6.5% |
| s | 629109 | 3.8% |
| m | 532538 | 3.3% |
| Other values (41) | 2340624 |
Common
| Value | Count | Frequency (%) |
| 2215902 | ||
| ) | 27827 | 1.2% |
| ( | 27827 | 1.2% |
| - | 10582 | 0.5% |
| ' | 264 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18627784 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 3037450 | |
| 2215902 | ||
| e | 1709137 | |
| t | 1704294 | |
| i | 1434438 | |
| o | 1338634 | |
| n | 1327976 | |
| l | 1227746 | |
| d | 1063436 | 5.7% |
| s | 629109 | 3.4% |
| Other values (46) | 2939662 |
metro
Text
| Distinct | 94 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.1 MiB |
Length
| Max length | 41 |
|---|---|
| Median length | 29 |
| Mean length | 23.187242 |
| Min length | 6 |
Characters and Unicode
| Total characters | 20953221 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | (not set) |
|---|---|
| 2nd row | not available in demo dataset |
| 3rd row | (not set) |
| 4th row | not available in demo dataset |
| 5th row | not available in demo dataset |
| Value | Count | Frequency (%) |
| not | 709995 | |
| in | 508284 | |
| available | 508229 | |
| demo | 508229 | |
| dataset | 508229 | |
| set | 201766 | 5.7% |
| ca | 107495 | 3.0% |
| san | 97670 | 2.7% |
| francisco-oakland-san | 95913 | 2.7% |
| jose | 95913 | 2.7% |
| Other values (161) | 221970 | 6.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 3084714 | |
| 2660040 | ||
| t | 1983594 | |
| e | 1908676 | |
| n | 1674938 | |
| o | 1522326 | |
| l | 1144979 | 5.5% |
| i | 1137893 | 5.4% |
| d | 1129116 | 5.4% |
| s | 947069 | 4.5% |
| Other values (47) | 3759876 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 16654529 | |
| Space Separator | 2660040 | 12.7% |
| Uppercase Letter | 1015958 | 4.8% |
| Dash Punctuation | 208990 | 1.0% |
| Open Punctuation | 205397 | 1.0% |
| Close Punctuation | 205397 | 1.0% |
| Other Punctuation | 2593 | < 0.1% |
| Connector Punctuation | 317 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 201944 | |
| A | 142147 | |
| C | 122747 | |
| O | 99783 | |
| F | 98863 | |
| J | 96257 | |
| N | 58712 | 5.8% |
| Y | 54047 | 5.3% |
| L | 33820 | 3.3% |
| T | 17187 | 1.7% |
| Other values (15) | 90451 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 3084714 | |
| t | 1983594 | |
| e | 1908676 | |
| n | 1674938 | |
| o | 1522326 | |
| l | 1144979 | 6.9% |
| i | 1137893 | 6.8% |
| d | 1129116 | 6.8% |
| s | 947069 | 5.7% |
| m | 517042 | 3.1% |
| Other values (14) | 1604182 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 2520 | |
| & | 61 | 2.4% |
| , | 12 | 0.5% |
Space Separator
| Value | Count | Frequency (%) |
| 2660040 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 208990 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 205397 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 205397 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 317 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 17670487 | |
| Common | 3282734 | 15.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 3084714 | |
| t | 1983594 | |
| e | 1908676 | |
| n | 1674938 | |
| o | 1522326 | |
| l | 1144979 | 6.5% |
| i | 1137893 | 6.4% |
| d | 1129116 | 6.4% |
| s | 947069 | 5.4% |
| m | 517042 | 2.9% |
| Other values (39) | 2620140 |
Common
| Value | Count | Frequency (%) |
| 2660040 | ||
| - | 208990 | 6.4% |
| ( | 205397 | 6.3% |
| ) | 205397 | 6.3% |
| . | 2520 | 0.1% |
| _ | 317 | < 0.1% |
| & | 61 | < 0.1% |
| , | 12 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 20953221 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 3084714 | |
| 2660040 | ||
| t | 1983594 | |
| e | 1908676 | |
| n | 1674938 | |
| o | 1522326 | |
| l | 1144979 | 5.5% |
| i | 1137893 | 5.4% |
| d | 1129116 | 5.4% |
| s | 947069 | 4.5% |
| Other values (47) | 3759876 |
city
Text
| Distinct | 649 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 66.5 MiB |
Length
| Max length | 33 |
|---|---|
| Median length | 29 |
| Mean length | 20.198846 |
| Min length | 3 |
Characters and Unicode
| Total characters | 18252748 |
|---|---|
| Distinct characters | 58 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Izmir |
|---|---|
| 2nd row | not available in demo dataset |
| 3rd row | Madrid |
| 4th row | not available in demo dataset |
| 5th row | not available in demo dataset |
| Value | Count | Frequency (%) |
| not | 542491 | |
| available | 508229 | |
| in | 508229 | |
| demo | 508229 | |
| dataset | 508229 | |
| mountain | 40884 | 1.3% |
| view | 40884 | 1.3% |
| san | 34510 | 1.1% |
| set | 34262 | 1.1% |
| new | 29593 | 0.9% |
| Other values (729) | 392267 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2851125 | |
| 2244154 | ||
| e | 1772459 | |
| t | 1723610 | |
| n | 1388588 | |
| o | 1327491 | |
| i | 1247087 | |
| l | 1121717 | 6.1% |
| d | 1065724 | 5.8% |
| s | 638731 | 3.5% |
| Other values (48) | 2872062 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 15395189 | |
| Space Separator | 2244154 | 12.3% |
| Uppercase Letter | 540915 | 3.0% |
| Close Punctuation | 34262 | 0.2% |
| Open Punctuation | 34262 | 0.2% |
| Dash Punctuation | 3850 | < 0.1% |
| Other Punctuation | 116 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 2851125 | |
| e | 1772459 | |
| t | 1723610 | |
| n | 1388588 | |
| o | 1327491 | |
| i | 1247087 | |
| l | 1121717 | 7.3% |
| d | 1065724 | 6.9% |
| s | 638731 | 4.1% |
| b | 545505 | 3.5% |
| Other values (17) | 1713152 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 77212 | |
| M | 73829 | |
| V | 44431 | 8.2% |
| C | 42122 | 7.8% |
| A | 34771 | 6.4% |
| N | 32069 | 5.9% |
| Y | 30238 | 5.6% |
| B | 29697 | 5.5% |
| L | 27718 | 5.1% |
| H | 25297 | 4.7% |
| Other values (15) | 123531 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 92 | |
| . | 24 | 20.7% |
Space Separator
| Value | Count | Frequency (%) |
| 2244154 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 34262 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 34262 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3850 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 15936104 | |
| Common | 2316644 | 12.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 2851125 | |
| e | 1772459 | |
| t | 1723610 | |
| n | 1388588 | |
| o | 1327491 | |
| i | 1247087 | |
| l | 1121717 | 7.0% |
| d | 1065724 | 6.7% |
| s | 638731 | 4.0% |
| b | 545505 | 3.4% |
| Other values (42) | 2254067 |
Common
| Value | Count | Frequency (%) |
| 2244154 | ||
| ) | 34262 | 1.5% |
| ( | 34262 | 1.5% |
| - | 3850 | 0.2% |
| ' | 92 | < 0.1% |
| . | 24 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18252664 | |
| None | 84 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 2851125 | |
| 2244154 | ||
| e | 1772459 | |
| t | 1723610 | |
| n | 1388588 | |
| o | 1327491 | |
| i | 1247087 | |
| l | 1121717 | 6.1% |
| d | 1065724 | 5.8% |
| s | 638731 | 3.5% |
| Other values (47) | 2871978 |
None
| Value | Count | Frequency (%) |
| ã | 84 |
networkDomain
Text
| Distinct | 28064 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 58.9 MiB |
Length
| Max length | 37 |
|---|---|
| Median length | 36 |
| Mean length | 11.307548 |
| Min length | 2 |
Characters and Unicode
| Total characters | 10218100 |
|---|---|
| Distinct characters | 44 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 14649 ? |
|---|---|
| Unique (%) | 1.6% |
Sample
| 1st row | ttnet.com.tr |
|---|---|
| 2nd row | dodo.net.au |
| 3rd row | unknown.unknown |
| 4th row | unknown.unknown |
| 5th row | unknown.unknown |
| Value | Count | Frequency (%) |
| not | 244881 | |
| set | 244881 | |
| unknown.unknown | 146034 | 12.7% |
| comcast.net | 28743 | 2.5% |
| rr.com | 14827 | 1.3% |
| verizon.net | 13637 | 1.2% |
| ttnet.com.tr | 13228 | 1.2% |
| comcastbusiness.net | 9985 | 0.9% |
| hinet.net | 7919 | 0.7% |
| virginm.net | 6414 | 0.6% |
| Other values (28055) | 417985 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 1652112 | |
| t | 1109389 | 10.9% |
| o | 976560 | 9.6% |
| e | 853294 | 8.4% |
| . | 764746 | 7.5% |
| s | 481477 | 4.7% |
| u | 410558 | 4.0% |
| c | 386518 | 3.8% |
| w | 332859 | 3.3% |
| k | 332681 | 3.3% |
| Other values (34) | 2917906 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 8642089 | |
| Other Punctuation | 764767 | 7.5% |
| Open Punctuation | 244881 | 2.4% |
| Close Punctuation | 244881 | 2.4% |
| Space Separator | 244881 | 2.4% |
| Decimal Number | 39097 | 0.4% |
| Dash Punctuation | 37500 | 0.4% |
| Connector Punctuation | 4 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 1652112 | |
| t | 1109389 | |
| o | 976560 | |
| e | 853294 | |
| s | 481477 | 5.6% |
| u | 410558 | 4.8% |
| c | 386518 | 4.5% |
| w | 332859 | 3.9% |
| k | 332681 | 3.8% |
| a | 310767 | 3.6% |
| Other values (16) | 1795874 |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 9720 | |
| 1 | 6911 | |
| 2 | 6125 | |
| 5 | 4066 | |
| 0 | 3520 | 9.0% |
| 8 | 3008 | 7.7% |
| 4 | 2346 | 6.0% |
| 9 | 1865 | 4.8% |
| 6 | 857 | 2.2% |
| 7 | 679 | 1.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 764746 | |
| \ | 13 | < 0.1% |
| @ | 8 | < 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 244881 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 244881 |
Space Separator
| Value | Count | Frequency (%) |
| 244881 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 37500 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 4 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8642089 | |
| Common | 1576011 | 15.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 1652112 | |
| t | 1109389 | |
| o | 976560 | |
| e | 853294 | |
| s | 481477 | 5.6% |
| u | 410558 | 4.8% |
| c | 386518 | 4.5% |
| w | 332859 | 3.9% |
| k | 332681 | 3.8% |
| a | 310767 | 3.6% |
| Other values (16) | 1795874 |
Common
| Value | Count | Frequency (%) |
| . | 764746 | |
| ( | 244881 | 15.5% |
| ) | 244881 | 15.5% |
| 244881 | 15.5% | |
| - | 37500 | 2.4% |
| 3 | 9720 | 0.6% |
| 1 | 6911 | 0.4% |
| 2 | 6125 | 0.4% |
| 5 | 4066 | 0.3% |
| 0 | 3520 | 0.2% |
| Other values (8) | 8780 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10218100 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 1652112 | |
| t | 1109389 | 10.9% |
| o | 976560 | 9.6% |
| e | 853294 | 8.4% |
| . | 764746 | 7.5% |
| s | 481477 | 4.7% |
| u | 410558 | 4.0% |
| c | 386518 | 3.8% |
| w | 332859 | 3.3% |
| k | 332681 | 3.3% |
| Other values (34) | 2917906 |
browser
Text
| Distinct | 54 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 54.7 MiB |
Length
| Max length | 43 |
|---|---|
| Median length | 6 |
| Mean length | 6.460627 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5838165 |
|---|---|
| Distinct characters | 68 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 14 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Chrome |
|---|---|
| 2nd row | Firefox |
| 3rd row | Chrome |
| 4th row | UC Browser |
| 5th row | Chrome |
| Value | Count | Frequency (%) |
| chrome | 620365 | |
| safari | 189095 | 19.9% |
| firefox | 37069 | 3.9% |
| internet | 19375 | 2.0% |
| explorer | 19375 | 2.0% |
| opera | 11782 | 1.2% |
| edge | 10205 | 1.1% |
| android | 8420 | 0.9% |
| webview | 7865 | 0.8% |
| in-app | 6850 | 0.7% |
| Other values (60) | 18727 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 935843 | |
| e | 759760 | |
| o | 693831 | |
| C | 624899 | |
| m | 621325 | |
| h | 620632 | |
| a | 400787 | |
| i | 263237 | 4.5% |
| f | 226356 | 3.9% |
| S | 189714 | 3.2% |
| Other values (58) | 501781 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4822831 | |
| Uppercase Letter | 948991 | 16.3% |
| Space Separator | 45475 | 0.8% |
| Dash Punctuation | 6866 | 0.1% |
| Open Punctuation | 6859 | 0.1% |
| Close Punctuation | 6859 | 0.1% |
| Decimal Number | 201 | < 0.1% |
| Connector Punctuation | 82 | < 0.1% |
| Other Punctuation | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 935843 | |
| e | 759760 | |
| o | 693831 | |
| m | 621325 | |
| h | 620632 | |
| a | 400787 | |
| i | 263237 | 5.5% |
| f | 226356 | 4.7% |
| n | 61814 | 1.3% |
| x | 56690 | 1.2% |
| Other values (16) | 182556 | 3.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 624899 | |
| S | 189714 | 20.0% |
| F | 37094 | 3.9% |
| E | 29851 | 3.1% |
| I | 19410 | 2.0% |
| O | 12046 | 1.3% |
| A | 9371 | 1.0% |
| W | 7865 | 0.8% |
| M | 7320 | 0.8% |
| B | 5654 | 0.6% |
| Other values (14) | 5767 | 0.6% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 63 | |
| 0 | 59 | |
| 1 | 29 | |
| 4 | 24 | 11.9% |
| 7 | 10 | 5.0% |
| 5 | 6 | 3.0% |
| 3 | 4 | 2.0% |
| 9 | 4 | 2.0% |
| 8 | 1 | 0.5% |
| 6 | 1 | 0.5% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 6858 | |
| [ | 1 | < 0.1% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 6858 | |
| ] | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 45475 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 6866 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 82 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5771822 | |
| Common | 66343 | 1.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 935843 | |
| e | 759760 | |
| o | 693831 | |
| C | 624899 | |
| m | 621325 | |
| h | 620632 | |
| a | 400787 | |
| i | 263237 | 4.6% |
| f | 226356 | 3.9% |
| S | 189714 | 3.3% |
| Other values (40) | 435438 |
Common
| Value | Count | Frequency (%) |
| 45475 | ||
| - | 6866 | 10.3% |
| ( | 6858 | 10.3% |
| ) | 6858 | 10.3% |
| _ | 82 | 0.1% |
| 2 | 63 | 0.1% |
| 0 | 59 | 0.1% |
| 1 | 29 | < 0.1% |
| 4 | 24 | < 0.1% |
| 7 | 10 | < 0.1% |
| Other values (8) | 19 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5838165 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 935843 | |
| e | 759760 | |
| o | 693831 | |
| C | 624899 | |
| m | 621325 | |
| h | 620632 | |
| a | 400787 | |
| i | 263237 | 4.5% |
| f | 226356 | 3.9% |
| S | 189714 | 3.2% |
| Other values (58) | 501781 |
operatingSystem
Categorical
HIGH CORRELATION 
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 MiB |
| Windows | |
|---|---|
| Macintosh | |
| Android | |
| iOS | |
| Linux | |
| Other values (15) | 33052 |
Length
| Max length | 13 |
|---|---|
| Median length | 7 |
| Mean length | 7.0862532 |
| Min length | 3 |
Characters and Unicode
| Total characters | 6403514 |
|---|---|
| Distinct characters | 41 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Windows |
|---|---|
| 2nd row | Macintosh |
| 3rd row | Windows |
| 4th row | Linux |
| 5th row | Android |
Common Values
| Value | Count | Frequency (%) |
| Windows | 350072 | |
| Macintosh | 253938 | |
| Android | 123892 | 13.7% |
| iOS | 107665 | 11.9% |
| Linux | 35034 | 3.9% |
| Chrome OS | 26337 | 2.9% |
| (not set) | 4695 | 0.5% |
| Windows Phone | 1216 | 0.1% |
| Samsung | 280 | < 0.1% |
| BlackBerry | 218 | < 0.1% |
| Other values (10) | 306 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| windows | 351288 | |
| macintosh | 253938 | |
| android | 123892 | 13.2% |
| ios | 107665 | 11.5% |
| linux | 35034 | 3.7% |
| os | 26426 | 2.8% |
| chrome | 26337 | 2.8% |
| not | 4695 | 0.5% |
| set | 4695 | 0.5% |
| phone | 1216 | 0.1% |
| Other values (14) | 941 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 872314 | |
| n | 770618 | |
| o | 761662 | |
| s | 610201 | |
| d | 599208 | |
| W | 351423 | 5.5% |
| w | 351288 | 5.5% |
| h | 281491 | 4.4% |
| t | 263464 | 4.1% |
| a | 254438 | 4.0% |
| Other values (31) | 1287407 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5300528 | |
| Uppercase Letter | 1061121 | 16.6% |
| Space Separator | 32474 | 0.5% |
| Open Punctuation | 4695 | 0.1% |
| Close Punctuation | 4695 | 0.1% |
| Decimal Number | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 872314 | |
| n | 770618 | |
| o | 761662 | |
| s | 610201 | |
| d | 599208 | |
| w | 351288 | |
| h | 281491 | 5.3% |
| t | 263464 | 5.0% |
| a | 254438 | 4.8% |
| c | 254156 | 4.8% |
| Other values (12) | 281688 | 5.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 351423 | |
| M | 253939 | |
| S | 134385 | 12.7% |
| O | 134094 | 12.6% |
| A | 123892 | 11.7% |
| L | 35034 | 3.3% |
| C | 26338 | 2.5% |
| P | 1216 | 0.1% |
| B | 447 | < 0.1% |
| N | 139 | < 0.1% |
| Other values (5) | 214 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 32474 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 4695 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 4695 |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6361649 | |
| Common | 41865 | 0.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 872314 | |
| n | 770618 | |
| o | 761662 | |
| s | 610201 | |
| d | 599208 | |
| W | 351423 | 5.5% |
| w | 351288 | 5.5% |
| h | 281491 | 4.4% |
| t | 263464 | 4.1% |
| a | 254438 | 4.0% |
| Other values (27) | 1245542 |
Common
| Value | Count | Frequency (%) |
| 32474 | ||
| ( | 4695 | 11.2% |
| ) | 4695 | 11.2% |
| 3 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6403514 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 872314 | |
| n | 770618 | |
| o | 761662 | |
| s | 610201 | |
| d | 599208 | |
| W | 351423 | 5.5% |
| w | 351288 | 5.5% |
| h | 281491 | 4.4% |
| t | 263464 | 4.1% |
| a | 254438 | 4.0% |
| Other values (31) | 1287407 |
isMobile
Boolean
HIGH CORRELATION 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 882.6 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 664530 | |
| True | 239123 | 26.5% |
deviceCategory
Categorical
HIGH CORRELATION 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 54.9 MiB |
| desktop | |
|---|---|
| mobile | |
| tablet | 30449 |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.7353254 |
| Min length | 6 |
Characters and Unicode
| Total characters | 6086397 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | desktop |
|---|---|
| 2nd row | desktop |
| 3rd row | desktop |
| 4th row | desktop |
| 5th row | mobile |
Common Values
| Value | Count | Frequency (%) |
| desktop | 664479 | |
| mobile | 208725 | 23.1% |
| tablet | 30449 | 3.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| desktop | 664479 | |
| mobile | 208725 | 23.1% |
| tablet | 30449 | 3.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 903653 | |
| o | 873204 | |
| t | 725377 | |
| d | 664479 | |
| s | 664479 | |
| k | 664479 | |
| p | 664479 | |
| b | 239174 | 3.9% |
| l | 239174 | 3.9% |
| m | 208725 | 3.4% |
| Other values (2) | 239174 | 3.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 6086397 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 903653 | |
| o | 873204 | |
| t | 725377 | |
| d | 664479 | |
| s | 664479 | |
| k | 664479 | |
| p | 664479 | |
| b | 239174 | 3.9% |
| l | 239174 | 3.9% |
| m | 208725 | 3.4% |
| Other values (2) | 239174 | 3.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6086397 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 903653 | |
| o | 873204 | |
| t | 725377 | |
| d | 664479 | |
| s | 664479 | |
| k | 664479 | |
| p | 664479 | |
| b | 239174 | 3.9% |
| l | 239174 | 3.9% |
| m | 208725 | 3.4% |
| Other values (2) | 239174 | 3.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6086397 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 903653 | |
| o | 873204 | |
| t | 725377 | |
| d | 664479 | |
| s | 664479 | |
| k | 664479 | |
| p | 664479 | |
| b | 239174 | 3.9% |
| l | 239174 | 3.9% |
| m | 208725 | 3.4% |
| Other values (2) | 239174 | 3.9% |
hits
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 274 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.5965376 |
| Minimum | 1 |
|---|---|
| Maximum | 500 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 18 |
| Maximum | 500 |
| Range | 499 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 9.6414371 |
|---|---|
| Coefficient of variation (CV) | 2.0975434 |
| Kurtosis | 230.35198 |
| Mean | 4.5965376 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 9.7804556 |
| Sum | 4153675 |
| Variance | 92.957308 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 446754 | |
| 2 | 137952 | 15.3% |
| 3 | 70402 | 7.8% |
| 4 | 42444 | 4.7% |
| 5 | 30939 | 3.4% |
| 6 | 23918 | 2.6% |
| 7 | 19518 | 2.2% |
| 8 | 15484 | 1.7% |
| 9 | 12959 | 1.4% |
| 10 | 10640 | 1.2% |
| Other values (264) | 92643 | 10.3% |
| Value | Count | Frequency (%) |
| 1 | 446754 | |
| 2 | 137952 | 15.3% |
| 3 | 70402 | 7.8% |
| 4 | 42444 | 4.7% |
| 5 | 30939 | 3.4% |
| 6 | 23918 | 2.6% |
| 7 | 19518 | 2.2% |
| 8 | 15484 | 1.7% |
| 9 | 12959 | 1.4% |
| 10 | 10640 | 1.2% |
| Value | Count | Frequency (%) |
| 500 | 10 | |
| 489 | 1 | < 0.1% |
| 483 | 1 | < 0.1% |
| 471 | 1 | < 0.1% |
| 445 | 1 | < 0.1% |
| 437 | 1 | < 0.1% |
| 406 | 1 | < 0.1% |
| 387 | 1 | < 0.1% |
| 386 | 1 | < 0.1% |
| 385 | 2 | < 0.1% |
pageviews
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 213 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 100 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.8497642 |
| Minimum | 1 |
|---|---|
| Maximum | 469 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 4 |
| 95-th percentile | 15 |
| Maximum | 469 |
| Range | 468 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 7.025274 |
|---|---|
| Coefficient of variation (CV) | 1.8248582 |
| Kurtosis | 237.41488 |
| Mean | 3.8497642 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.2150555 |
| Sum | 3478466 |
| Variance | 49.354474 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 452522 | |
| 2 | 143770 | 15.9% |
| 3 | 73835 | 8.2% |
| 4 | 45192 | 5.0% |
| 5 | 33411 | 3.7% |
| 6 | 24688 | 2.7% |
| 7 | 19476 | 2.2% |
| 8 | 15272 | 1.7% |
| 9 | 12585 | 1.4% |
| 10 | 10104 | 1.1% |
| Other values (203) | 72698 | 8.0% |
| Value | Count | Frequency (%) |
| 1 | 452522 | |
| 2 | 143770 | 15.9% |
| 3 | 73835 | 8.2% |
| 4 | 45192 | 5.0% |
| 5 | 33411 | 3.7% |
| 6 | 24688 | 2.7% |
| 7 | 19476 | 2.2% |
| 8 | 15272 | 1.7% |
| 9 | 12585 | 1.4% |
| 10 | 10104 | 1.1% |
| Value | Count | Frequency (%) |
| 469 | 1 | |
| 466 | 1 | |
| 431 | 1 | |
| 429 | 1 | |
| 400 | 1 | |
| 358 | 1 | |
| 351 | 1 | |
| 343 | 1 | |
| 341 | 2 | |
| 340 | 1 |
transactionRevenue
Real number (ℝ)
MISSING  SKEWED 
| Distinct | 5332 |
|---|---|
| Distinct (%) | 46.3% |
| Missing | 892138 |
| Missing (%) | 98.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.3374479 × 108 |
| Minimum | 10000 |
|---|---|
| Maximum | 2.31295 × 1010 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 10000 |
|---|---|
| 5-th percentile | 10630000 |
| Q1 | 24930000 |
| median | 49450000 |
| Q3 | 1.07655 × 108 |
| 95-th percentile | 4.92576 × 108 |
| Maximum | 2.31295 × 1010 |
| Range | 2.312949 × 1010 |
| Interquartile range (IQR) | 82725000 |
Descriptive statistics
| Standard deviation | 4.4828523 × 108 |
|---|---|
| Coefficient of variation (CV) | 3.3517959 |
| Kurtosis | 1020.3068 |
| Mean | 1.3374479 × 108 |
| Median Absolute Deviation (MAD) | 30470000 |
| Skewness | 25.722703 |
| Sum | 1.5400712 × 1012 |
| Variance | 2.0095965 × 1017 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16990000 | 256 | < 0.1% |
| 18990000 | 189 | < 0.1% |
| 33590000 | 187 | < 0.1% |
| 44790000 | 170 | < 0.1% |
| 13590000 | 135 | < 0.1% |
| 55990000 | 122 | < 0.1% |
| 19990000 | 116 | < 0.1% |
| 15990000 | 98 | < 0.1% |
| 15190000 | 93 | < 0.1% |
| 19190000 | 92 | < 0.1% |
| Other values (5322) | 10057 | 1.1% |
| (Missing) | 892138 |
| Value | Count | Frequency (%) |
| 10000 | 1 | < 0.1% |
| 40000 | 1 | < 0.1% |
| 90000 | 1 | < 0.1% |
| 160000 | 1 | < 0.1% |
| 200000 | 1 | < 0.1% |
| 490000 | 1 | < 0.1% |
| 770000 | 1 | < 0.1% |
| 790000 | 1 | < 0.1% |
| 990000 | 1 | < 0.1% |
| 1200000 | 7 |
| Value | Count | Frequency (%) |
| 2.31295 × 1010 | 1 | |
| 1.78555 × 1010 | 1 | |
| 1.602375 × 1010 | 1 | |
| 1.058914 × 1010 | 1 | |
| 8677830000 | 1 | |
| 8248800000 | 1 | |
| 6996500000 | 1 | |
| 6826960000 | 1 | |
| 6248750000 | 1 | |
| 5614440000 | 1 |
campaign
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 57.4 MiB |
| (not set) | |
|---|---|
| Data Share Promo | 16403 |
| AW - Dynamic Search Ads Whole Site | 14244 |
| AW - Accessories | 7070 |
| test-liyuhz | 392 |
| Other values (5) | 197 |
Length
| Max length | 47 |
|---|---|
| Median length | 9 |
| Mean length | 9.5797779 |
| Min length | 9 |
Characters and Unicode
| Total characters | 8656795 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | (not set) |
|---|---|
| 2nd row | (not set) |
| 3rd row | (not set) |
| 4th row | (not set) |
| 5th row | (not set) |
Common Values
| Value | Count | Frequency (%) |
| (not set) | 865347 | |
| Data Share Promo | 16403 | 1.8% |
| AW - Dynamic Search Ads Whole Site | 14244 | 1.6% |
| AW - Accessories | 7070 | 0.8% |
| test-liyuhz | 392 | < 0.1% |
| AW - Electronics | 96 | < 0.1% |
| Retail (DO NOT EDIT owners nophakun and tianyu) | 50 | < 0.1% |
| AW - Apparel | 46 | < 0.1% |
| All Products | 4 | < 0.1% |
| Data Share | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| not | 865397 | |
| set | 865347 | |
| aw | 21456 | 1.1% |
| 21456 | 1.1% | |
| data | 16404 | 0.9% |
| share | 16404 | 0.9% |
| promo | 16403 | 0.9% |
| dynamic | 14244 | 0.7% |
| search | 14244 | 0.7% |
| ads | 14244 | 0.7% |
| Other values (15) | 36450 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 1762326 | |
| 998396 | ||
| e | 939257 | |
| o | 919667 | |
| s | 901343 | |
| n | 879937 | |
| ) | 865397 | |
| ( | 865397 | |
| a | 77946 | 0.9% |
| r | 54317 | 0.6% |
| Other values (24) | 392812 | 4.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5734694 | |
| Space Separator | 998396 | 11.5% |
| Close Punctuation | 865397 | 10.0% |
| Open Punctuation | 865397 | 10.0% |
| Uppercase Letter | 171063 | 2.0% |
| Dash Punctuation | 21848 | 0.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 1762326 | |
| e | 939257 | |
| o | 919667 | |
| s | 901343 | |
| n | 879937 | |
| a | 77946 | 1.4% |
| r | 54317 | 0.9% |
| h | 45334 | 0.8% |
| c | 42824 | 0.7% |
| i | 36146 | 0.6% |
| Other values (9) | 75597 | 1.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 44892 | |
| A | 42820 | |
| W | 35700 | |
| D | 30748 | |
| P | 16407 | 9.6% |
| E | 146 | 0.1% |
| O | 100 | 0.1% |
| T | 100 | 0.1% |
| R | 50 | < 0.1% |
| N | 50 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 998396 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 865397 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 865397 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 21848 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5905757 | |
| Common | 2751038 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 1762326 | |
| e | 939257 | |
| o | 919667 | |
| s | 901343 | |
| n | 879937 | |
| a | 77946 | 1.3% |
| r | 54317 | 0.9% |
| h | 45334 | 0.8% |
| S | 44892 | 0.8% |
| c | 42824 | 0.7% |
| Other values (20) | 237914 | 4.0% |
Common
| Value | Count | Frequency (%) |
| 998396 | ||
| ) | 865397 | |
| ( | 865397 | |
| - | 21848 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8656795 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 1762326 | |
| 998396 | ||
| e | 939257 | |
| o | 919667 | |
| s | 901343 | |
| n | 879937 | |
| ) | 865397 | |
| ( | 865397 | |
| a | 77946 | 0.9% |
| r | 54317 | 0.6% |
| Other values (24) | 392812 | 4.5% |
source
Text
| Distinct | 380 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 56.9 MiB |
Length
| Max length | 60 |
|---|---|
| Median length | 49 |
| Mean length | 9.0206938 |
| Min length | 3 |
Characters and Unicode
| Total characters | 8151577 |
|---|---|
| Distinct characters | 43 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 125 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
| Value | Count | Frequency (%) |
| 400788 | ||
| youtube.com | 212602 | |
| direct | 143028 | 15.8% |
| mall.googleplex.com | 66416 | 7.3% |
| partners | 16411 | 1.8% |
| analytics.google.com | 16172 | 1.8% |
| dfa | 5686 | 0.6% |
| google.com | 4669 | 0.5% |
| m.facebook.com | 3365 | 0.4% |
| baidu | 3356 | 0.4% |
| Other values (371) | 31229 | 3.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 1571376 | |
| g | 1006376 | |
| e | 958629 | |
| l | 730101 | |
| c | 500801 | 6.1% |
| u | 437502 | 5.4% |
| . | 434839 | 5.3% |
| t | 402952 | 4.9% |
| m | 401095 | 4.9% |
| y | 233355 | 2.9% |
| Other values (33) | 1474551 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7412657 | |
| Other Punctuation | 434933 | 5.3% |
| Open Punctuation | 143097 | 1.8% |
| Close Punctuation | 143097 | 1.8% |
| Uppercase Letter | 16411 | 0.2% |
| Decimal Number | 971 | < 0.1% |
| Dash Punctuation | 342 | < 0.1% |
| Space Separator | 69 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 1571376 | |
| g | 1006376 | |
| e | 958629 | |
| l | 730101 | |
| c | 500801 | 6.8% |
| u | 437502 | 5.9% |
| t | 402952 | 5.4% |
| m | 401095 | 5.4% |
| y | 233355 | 3.1% |
| b | 228412 | 3.1% |
| Other values (16) | 942058 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 305 | |
| 2 | 273 | |
| 8 | 132 | |
| 9 | 97 | 10.0% |
| 3 | 39 | 4.0% |
| 1 | 38 | 3.9% |
| 5 | 31 | 3.2% |
| 6 | 24 | 2.5% |
| 4 | 20 | 2.1% |
| 7 | 12 | 1.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 434839 | |
| : | 94 | < 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 143097 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 143097 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 16411 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 342 |
Space Separator
| Value | Count | Frequency (%) |
| 69 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7429068 | |
| Common | 722509 | 8.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 1571376 | |
| g | 1006376 | |
| e | 958629 | |
| l | 730101 | |
| c | 500801 | 6.7% |
| u | 437502 | 5.9% |
| t | 402952 | 5.4% |
| m | 401095 | 5.4% |
| y | 233355 | 3.1% |
| b | 228412 | 3.1% |
| Other values (17) | 958469 |
Common
| Value | Count | Frequency (%) |
| . | 434839 | |
| ( | 143097 | 19.8% |
| ) | 143097 | 19.8% |
| - | 342 | < 0.1% |
| 0 | 305 | < 0.1% |
| 2 | 273 | < 0.1% |
| 8 | 132 | < 0.1% |
| 9 | 97 | < 0.1% |
| : | 94 | < 0.1% |
| 69 | < 0.1% | |
| Other values (6) | 164 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8151577 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 1571376 | |
| g | 1006376 | |
| e | 958629 | |
| l | 730101 | |
| c | 500801 | 6.1% |
| u | 437502 | 5.4% |
| . | 434839 | 5.3% |
| t | 402952 | 4.9% |
| m | 401095 | 4.9% |
| y | 233355 | 2.9% |
| Other values (33) | 1474551 |
medium
Categorical
HIGH CORRELATION 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.2 MiB |
| organic | |
|---|---|
| referral | |
| (none) | |
| cpc | 25326 |
| affiliate | 16403 |
| Other values (2) | 6382 |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 7.1047117 |
| Min length | 3 |
Characters and Unicode
| Total characters | 6420194 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | organic |
|---|---|
| 2nd row | organic |
| 3rd row | organic |
| 4th row | organic |
| 5th row | organic |
Common Values
| Value | Count | Frequency (%) |
| organic | 381561 | |
| referral | 330955 | |
| (none) | 143026 | 15.8% |
| cpc | 25326 | 2.8% |
| affiliate | 16403 | 1.8% |
| cpm | 6262 | 0.7% |
| (not set) | 120 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| organic | 381561 | |
| referral | 330955 | |
| none | 143026 | 15.8% |
| cpc | 25326 | 2.8% |
| affiliate | 16403 | 1.8% |
| cpm | 6262 | 0.7% |
| not | 120 | < 0.1% |
| set | 120 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 1374426 | |
| e | 821459 | |
| a | 745322 | |
| n | 667733 | |
| o | 524707 | 8.2% |
| c | 438475 | 6.8% |
| i | 414367 | 6.5% |
| g | 381561 | 5.9% |
| f | 363761 | 5.7% |
| l | 347358 | 5.4% |
| Other values (7) | 341025 | 5.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 6133782 | |
| Open Punctuation | 143146 | 2.2% |
| Close Punctuation | 143146 | 2.2% |
| Space Separator | 120 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 1374426 | |
| e | 821459 | |
| a | 745322 | |
| n | 667733 | |
| o | 524707 | 8.6% |
| c | 438475 | 7.1% |
| i | 414367 | 6.8% |
| g | 381561 | 6.2% |
| f | 363761 | 5.9% |
| l | 347358 | 5.7% |
| Other values (4) | 54613 | 0.9% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 143146 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 143146 |
Space Separator
| Value | Count | Frequency (%) |
| 120 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6133782 | |
| Common | 286412 | 4.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 1374426 | |
| e | 821459 | |
| a | 745322 | |
| n | 667733 | |
| o | 524707 | 8.6% |
| c | 438475 | 7.1% |
| i | 414367 | 6.8% |
| g | 381561 | 6.2% |
| f | 363761 | 5.9% |
| l | 347358 | 5.7% |
| Other values (4) | 54613 | 0.9% |
Common
| Value | Count | Frequency (%) |
| ( | 143146 | |
| ) | 143146 | |
| 120 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6420194 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 1374426 | |
| e | 821459 | |
| a | 745322 | |
| n | 667733 | |
| o | 524707 | 8.2% |
| c | 438475 | 6.8% |
| i | 414367 | 6.5% |
| g | 381561 | 5.9% |
| f | 363761 | 5.7% |
| l | 347358 | 5.4% |
| Other values (7) | 341025 | 5.3% |
keyword
Text
MISSING 
| Distinct | 3659 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 502929 |
| Missing (%) | 55.7% |
| Memory size | 42.6 MiB |
Length
| Max length | 147 |
|---|---|
| Median length | 14 |
| Mean length | 14.332388 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5743332 |
|---|---|
| Distinct characters | 295 |
| Distinct categories | 18 ? |
| Distinct scripts | 13 ? |
| Distinct blocks | 14 ? |
Unique
| Unique | 2763 ? |
|---|---|
| Unique (%) | 0.7% |
Sample
| 1st row | (not provided) |
|---|---|
| 2nd row | (not provided) |
| 3rd row | (not provided) |
| 4th row | google + online |
| 5th row | (not provided) |
| Value | Count | Frequency (%) |
| not | 366363 | |
| provided | 366363 | |
| 6qehscssdk0z36ri | 11503 | 1.5% |
| 10301 | 1.3% | |
| merchandise | 5671 | 0.7% |
| store | 5316 | 0.7% |
| targeting | 3086 | 0.4% |
| youtube | 2833 | 0.4% |
| remarketing/content | 2298 | 0.3% |
| 1hzbaqlcbjwfgoh7 | 2264 | 0.3% |
| Other values (2422) | 16694 | 2.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 772784 | |
| d | 752095 | |
| e | 416576 | 7.3% |
| r | 401124 | 7.0% |
| t | 397351 | 6.9% |
| i | 395175 | 6.9% |
| 391968 | 6.8% | |
| n | 386835 | 6.7% |
| ( | 369878 | 6.4% |
| ) | 369877 | 6.4% |
| Other values (285) | 1089669 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4480669 | |
| Space Separator | 391968 | 6.8% |
| Open Punctuation | 369878 | 6.4% |
| Close Punctuation | 369877 | 6.4% |
| Uppercase Letter | 66215 | 1.2% |
| Decimal Number | 53129 | 0.9% |
| Other Punctuation | 5413 | 0.1% |
| Math Symbol | 4796 | 0.1% |
| Dash Punctuation | 690 | < 0.1% |
| Other Letter | 496 | < 0.1% |
| Other values (8) | 201 | < 0.1% |
Most frequent character per category
Other Letter
| Value | Count | Frequency (%) |
| 网 | 38 | 7.7% |
| 官 | 37 | 7.5% |
| 商 | 34 | 6.9% |
| 店 | 32 | 6.5% |
| ক | 17 | 3.4% |
| র | 16 | 3.2% |
| シ | 13 | 2.6% |
| ツ | 12 | 2.4% |
| ャ | 12 | 2.4% |
| 谷 | 11 | 2.2% |
| Other values (118) | 274 |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 772784 | |
| d | 752095 | |
| e | 416576 | |
| r | 401124 | |
| t | 397351 | |
| i | 395175 | |
| n | 386835 | |
| p | 368763 | |
| v | 367210 | |
| s | 52440 | 1.2% |
| Other values (71) | 170316 | 3.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 16135 | |
| K | 12009 | |
| E | 11748 | |
| G | 3090 | 4.7% |
| M | 2992 | 4.5% |
| Z | 2732 | 4.1% |
| A | 2494 | 3.8% |
| R | 2472 | 3.7% |
| O | 2455 | 3.7% |
| H | 2376 | 3.6% |
| Other values (18) | 7712 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 3604 | |
| . | 1181 | 21.8% |
| : | 332 | 6.1% |
| & | 144 | 2.7% |
| ? | 43 | 0.8% |
| ' | 33 | 0.6% |
| * | 26 | 0.5% |
| , | 17 | 0.3% |
| " | 15 | 0.3% |
| # | 7 | 0.1% |
| Other values (4) | 11 | 0.2% |
Spacing Mark
| Value | Count | Frequency (%) |
| া | 29 | |
| ে | 14 | |
| ি | 8 | 12.3% |
| ा | 3 | 4.6% |
| ী | 3 | 4.6% |
| ো | 2 | 3.1% |
| ो | 2 | 3.1% |
| ॉ | 1 | 1.5% |
| ੀ | 1 | 1.5% |
| ी | 1 | 1.5% |
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 23566 | |
| 0 | 12053 | |
| 3 | 11550 | |
| 1 | 2936 | 5.5% |
| 7 | 2288 | 4.3% |
| 4 | 507 | 1.0% |
| 2 | 127 | 0.2% |
| 5 | 53 | 0.1% |
| 9 | 32 | 0.1% |
| 8 | 17 | < 0.1% |
Nonspacing Mark
| Value | Count | Frequency (%) |
| ্ | 9 | |
| ू | 5 | |
| ् | 5 | |
| ূ | 3 | 10.3% |
| ु | 2 | 6.9% |
| े | 2 | 6.9% |
| ँ | 1 | 3.4% |
| ু | 1 | 3.4% |
| ं | 1 | 3.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 688 | |
| – | 1 | 0.1% |
| ‑ | 1 | 0.1% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 4577 | |
| = | 219 | 4.6% |
Space Separator
| Value | Count | Frequency (%) |
| 391968 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 369878 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 369877 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 99 |
Format
| Value | Count | Frequency (%) |
| | 3 |
Modifier Letter
| Value | Count | Frequency (%) |
| ー | 2 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 1 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ¨ | 1 |
Other Symbol
| Value | Count | Frequency (%) |
| 👉 | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4546613 | |
| Common | 1195858 | 20.8% |
| Cyrillic | 227 | < 0.1% |
| Bengali | 190 | < 0.1% |
| Han | 186 | < 0.1% |
| Katakana | 71 | < 0.1% |
| Devanagari | 69 | < 0.1% |
| Arabic | 50 | < 0.1% |
| Greek | 44 | < 0.1% |
| Hangul | 10 | < 0.1% |
| Other values (3) | 14 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 772784 | |
| d | 752095 | |
| e | 416576 | |
| r | 401124 | |
| t | 397351 | |
| i | 395175 | |
| n | 386835 | |
| p | 368763 | |
| v | 367210 | |
| s | 52440 | 1.2% |
| Other values (59) | 236260 | 5.2% |
Common
| Value | Count | Frequency (%) |
| 391968 | ||
| ( | 369878 | |
| ) | 369877 | |
| 6 | 23566 | 2.0% |
| 0 | 12053 | 1.0% |
| 3 | 11550 | 1.0% |
| + | 4577 | 0.4% |
| / | 3604 | 0.3% |
| 1 | 2936 | 0.2% |
| 7 | 2288 | 0.2% |
| Other values (28) | 3561 | 0.3% |
Bengali
| Value | Count | Frequency (%) |
| া | 29 | |
| ক | 17 | 8.9% |
| র | 16 | 8.4% |
| ে | 14 | 7.4% |
| প | 9 | 4.7% |
| ্ | 9 | 4.7% |
| ন | 8 | 4.2% |
| ি | 8 | 4.2% |
| ট | 7 | 3.7% |
| ই | 6 | 3.2% |
| Other values (25) | 67 |
Han
| Value | Count | Frequency (%) |
| 网 | 38 | |
| 官 | 37 | |
| 商 | 34 | |
| 店 | 32 | |
| 谷 | 11 | 5.9% |
| 歌 | 10 | 5.4% |
| 城 | 2 | 1.1% |
| 镜 | 1 | 0.5% |
| 件 | 1 | 0.5% |
| 在 | 1 | 0.5% |
| Other values (19) | 19 |
Cyrillic
| Value | Count | Frequency (%) |
| а | 21 | 9.3% |
| о | 20 | 8.8% |
| г | 20 | 8.8% |
| т | 19 | 8.4% |
| р | 16 | 7.0% |
| н | 16 | 7.0% |
| и | 13 | 5.7% |
| у | 13 | 5.7% |
| к | 11 | 4.8% |
| е | 11 | 4.8% |
| Other values (15) | 67 |
Devanagari
| Value | Count | Frequency (%) |
| ट | 7 | 10.1% |
| ग | 7 | 10.1% |
| ू | 5 | 7.2% |
| र | 5 | 7.2% |
| ् | 5 | 7.2% |
| ल | 4 | 5.8% |
| श | 4 | 5.8% |
| स | 4 | 5.8% |
| ा | 3 | 4.3% |
| य | 3 | 4.3% |
| Other values (15) | 22 |
Katakana
| Value | Count | Frequency (%) |
| シ | 13 | |
| ツ | 12 | |
| ャ | 12 | |
| グ | 5 | 7.0% |
| ン | 5 | 7.0% |
| ッ | 3 | 4.2% |
| イ | 3 | 4.2% |
| ル | 2 | 2.8% |
| ラ | 2 | 2.8% |
| ア | 2 | 2.8% |
| Other values (11) | 12 |
Arabic
| Value | Count | Frequency (%) |
| و | 11 | |
| ي | 10 | |
| ت | 7 | |
| ب | 6 | |
| غ | 2 | 4.0% |
| ل | 2 | 4.0% |
| ج | 2 | 4.0% |
| س | 2 | 4.0% |
| ی | 2 | 4.0% |
| ح | 1 | 2.0% |
| Other values (5) | 5 |
Greek
| Value | Count | Frequency (%) |
| ο | 8 | |
| λ | 5 | |
| α | 5 | |
| τ | 5 | |
| γ | 3 | 6.8% |
| π | 3 | 6.8% |
| υ | 3 | 6.8% |
| ι | 3 | 6.8% |
| ε | 3 | 6.8% |
| η | 1 | 2.3% |
| Other values (5) | 5 |
Hangul
| Value | Count | Frequency (%) |
| 셔 | 1 | |
| ㅕ | 1 | |
| ㅠ | 1 | |
| 채 | 1 | |
| ㅡ | 1 | |
| 글 | 1 | |
| 구 | 1 | |
| ㄷ | 1 | |
| ㅛ | 1 | |
| ㅐ | 1 |
Hebrew
| Value | Count | Frequency (%) |
| ס | 2 | |
| ק | 1 | |
| י | 1 | |
| ר | 1 | |
| ת | 1 | |
| א | 1 |
Hiragana
| Value | Count | Frequency (%) |
| を | 1 | |
| る | 1 | |
| す | 1 | |
| の | 1 |
Gurmukhi
| Value | Count | Frequency (%) |
| ਠ | 1 | |
| ੀ | 1 | |
| ਢ | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5742438 | |
| Cyrillic | 227 | < 0.1% |
| Bengali | 190 | < 0.1% |
| CJK | 186 | < 0.1% |
| Katakana | 73 | < 0.1% |
| None | 70 | < 0.1% |
| Devanagari | 69 | < 0.1% |
| Arabic | 50 | < 0.1% |
| Hebrew | 7 | < 0.1% |
| Compat Jamo | 6 | < 0.1% |
| Other values (4) | 16 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 772784 | |
| d | 752095 | |
| e | 416576 | 7.3% |
| r | 401124 | 7.0% |
| t | 397351 | 6.9% |
| i | 395175 | 6.9% |
| 391968 | 6.8% | |
| n | 386835 | 6.7% |
| ( | 369878 | 6.4% |
| ) | 369877 | 6.4% |
| Other values (74) | 1088775 |
CJK
| Value | Count | Frequency (%) |
| 网 | 38 | |
| 官 | 37 | |
| 商 | 34 | |
| 店 | 32 | |
| 谷 | 11 | 5.9% |
| 歌 | 10 | 5.4% |
| 城 | 2 | 1.1% |
| 镜 | 1 | 0.5% |
| 件 | 1 | 0.5% |
| 在 | 1 | 0.5% |
| Other values (19) | 19 |
Bengali
| Value | Count | Frequency (%) |
| া | 29 | |
| ক | 17 | 8.9% |
| র | 16 | 8.4% |
| ে | 14 | 7.4% |
| প | 9 | 4.7% |
| ্ | 9 | 4.7% |
| ন | 8 | 4.2% |
| ি | 8 | 4.2% |
| ট | 7 | 3.7% |
| ই | 6 | 3.2% |
| Other values (25) | 67 |
Cyrillic
| Value | Count | Frequency (%) |
| а | 21 | 9.3% |
| о | 20 | 8.8% |
| г | 20 | 8.8% |
| т | 19 | 8.4% |
| р | 16 | 7.0% |
| н | 16 | 7.0% |
| и | 13 | 5.7% |
| у | 13 | 5.7% |
| к | 11 | 4.8% |
| е | 11 | 4.8% |
| Other values (15) | 67 |
Katakana
| Value | Count | Frequency (%) |
| シ | 13 | |
| ツ | 12 | |
| ャ | 12 | |
| グ | 5 | 6.8% |
| ン | 5 | 6.8% |
| ッ | 3 | 4.1% |
| イ | 3 | 4.1% |
| ー | 2 | 2.7% |
| ル | 2 | 2.7% |
| ラ | 2 | 2.7% |
| Other values (12) | 14 |
Arabic
| Value | Count | Frequency (%) |
| و | 11 | |
| ي | 10 | |
| ت | 7 | |
| ب | 6 | |
| غ | 2 | 4.0% |
| ل | 2 | 4.0% |
| ج | 2 | 4.0% |
| س | 2 | 4.0% |
| ی | 2 | 4.0% |
| ح | 1 | 2.0% |
| Other values (5) | 5 |
None
| Value | Count | Frequency (%) |
| ο | 8 | 11.4% |
| ñ | 7 | 10.0% |
| λ | 5 | 7.1% |
| α | 5 | 7.1% |
| τ | 5 | 7.1% |
| γ | 3 | 4.3% |
| π | 3 | 4.3% |
| υ | 3 | 4.3% |
| ι | 3 | 4.3% |
| ε | 3 | 4.3% |
| Other values (24) | 25 |
Devanagari
| Value | Count | Frequency (%) |
| ट | 7 | 10.1% |
| ग | 7 | 10.1% |
| ू | 5 | 7.2% |
| र | 5 | 7.2% |
| ् | 5 | 7.2% |
| ल | 4 | 5.8% |
| श | 4 | 5.8% |
| स | 4 | 5.8% |
| ा | 3 | 4.3% |
| य | 3 | 4.3% |
| Other values (15) | 22 |
Punctuation
| Value | Count | Frequency (%) |
| | 3 | |
| – | 1 | 20.0% |
| ‑ | 1 | 20.0% |
Hebrew
| Value | Count | Frequency (%) |
| ס | 2 | |
| ק | 1 | |
| י | 1 | |
| ר | 1 | |
| ת | 1 | |
| א | 1 |
Hangul
| Value | Count | Frequency (%) |
| 셔 | 1 | |
| 채 | 1 | |
| 글 | 1 | |
| 구 | 1 |
Compat Jamo
| Value | Count | Frequency (%) |
| ㅕ | 1 | |
| ㅠ | 1 | |
| ㅡ | 1 | |
| ㄷ | 1 | |
| ㅛ | 1 | |
| ㅐ | 1 |
Gurmukhi
| Value | Count | Frequency (%) |
| ਠ | 1 | |
| ੀ | 1 | |
| ਢ | 1 |
Hiragana
| Value | Count | Frequency (%) |
| を | 1 | |
| る | 1 | |
| す | 1 | |
| の | 1 |
referralPath
Path
MISSING 
| Distinct | 1475 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 572712 |
| Missing (%) | 63.4% |
| Memory size | 39.5 MiB |
| / | |
|---|---|
| /yt/about/ | |
| /analytics/web/ | |
| /yt/about/tr/ | |
| /yt/about/vi/ | 13753 |
| Other values (1470) |
Length
| Max length | 270 |
|---|---|
| Median length | 227 |
| Mean length | 12.654307 |
| Min length | 1 |
Characters and Unicode
| Total characters | 4187829 |
|---|---|
| Distinct characters | 80 |
| Distinct categories | 8 ? |
| Distinct scripts | 3 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 616 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | / |
|---|---|
| 2nd row | / |
| 3rd row | /corp/google.com/study/incentives/working-with-perks |
| 4th row | /od/Things-To-Do-in-Silicon-Valley/fl/How-To-Visit-the-Googleplex-the-Google-Head-Office-in-Mountain-View.htm |
| 5th row | /od/Things-To-Do-in-Silicon-Valley/fl/How-To-Visit-the-Googleplex-the-Google-Head-Office-in-Mountain-View.htm |
Common Values
| Value | Count | Frequency (%) |
| / | 75523 | 8.4% |
| /yt/about/ | 71036 | 7.9% |
| /analytics/web/ | 14620 | 1.6% |
| /yt/about/tr/ | 14599 | 1.6% |
| /yt/about/vi/ | 13753 | 1.5% |
| /yt/about/es-419/ | 12735 | 1.4% |
| /yt/about/pt-BR/ | 12003 | 1.3% |
| /yt/about/th/ | 11430 | 1.3% |
| /yt/about/ru/ | 11193 | 1.2% |
| /yt/about/es/ | 7092 | 0.8% |
| Other values (1465) | 86957 | 9.6% |
| (Missing) | 572712 |
Length
| Value | Count | Frequency (%) |
| 75523 | ||
| yt/about | 71036 | |
| analytics/web | 14620 | 4.4% |
| yt/about/tr | 14599 | 4.4% |
| yt/about/vi | 13753 | 4.2% |
| yt/about/es-419 | 12735 | 3.8% |
| yt/about/pt-br | 12003 | 3.6% |
| yt/about/th | 11430 | 3.5% |
| yt/about/ru | 11193 | 3.4% |
| yt/about/es | 7092 | 2.1% |
| Other values (1455) | 86957 |
Most occurring characters
| Value | Count | Frequency (%) |
| / | 986276 | |
| t | 539889 | |
| o | 313010 | 7.5% |
| a | 299566 | 7.2% |
| u | 248905 | 5.9% |
| b | 239785 | 5.7% |
| y | 235075 | 5.6% |
| e | 137264 | 3.3% |
| - | 116586 | 2.8% |
| i | 108143 | 2.6% |
| Other values (70) | 963330 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2837830 | |
| Other Punctuation | 1002859 | 23.9% |
| Dash Punctuation | 116586 | 2.8% |
| Uppercase Letter | 113210 | 2.7% |
| Decimal Number | 96366 | 2.3% |
| Connector Punctuation | 19108 | 0.5% |
| Math Symbol | 1862 | < 0.1% |
| Other Letter | 8 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 539889 | |
| o | 313010 | |
| a | 299566 | |
| u | 248905 | |
| b | 239785 | |
| y | 235075 | |
| e | 137264 | 4.8% |
| i | 108143 | 3.8% |
| s | 101202 | 3.6% |
| n | 87445 | 3.1% |
| Other values (16) | 527546 |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 20815 | |
| G | 13512 | |
| R | 13108 | |
| T | 10994 | 9.7% |
| V | 6806 | 6.0% |
| H | 5551 | 4.9% |
| W | 4236 | 3.7% |
| I | 4028 | 3.6% |
| D | 3622 | 3.2% |
| M | 3051 | 2.7% |
| Other values (16) | 27487 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 25651 | |
| 4 | 19573 | |
| 9 | 19453 | |
| 0 | 8132 | 8.4% |
| 7 | 5765 | 6.0% |
| 2 | 5212 | 5.4% |
| 6 | 4462 | 4.6% |
| 5 | 3207 | 3.3% |
| 3 | 2764 | 2.9% |
| 8 | 2147 | 2.2% |
Other Letter
| Value | Count | Frequency (%) |
| س | 2 | |
| ف | 1 | |
| ي | 1 | |
| ل | 1 | |
| م | 1 | |
| ك | 1 | |
| ى | 1 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 986276 | |
| . | 15578 | 1.6% |
| % | 836 | 0.1% |
| , | 124 | < 0.1% |
| : | 44 | < 0.1% |
| @ | 1 | < 0.1% |
Math Symbol
| Value | Count | Frequency (%) |
| = | 1829 | |
| + | 32 | 1.7% |
| ~ | 1 | 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 116586 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 19108 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2951040 | |
| Common | 1236781 | |
| Arabic | 8 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 539889 | |
| o | 313010 | |
| a | 299566 | |
| u | 248905 | 8.4% |
| b | 239785 | 8.1% |
| y | 235075 | 8.0% |
| e | 137264 | 4.7% |
| i | 108143 | 3.7% |
| s | 101202 | 3.4% |
| n | 87445 | 3.0% |
| Other values (42) | 640756 |
Common
| Value | Count | Frequency (%) |
| / | 986276 | |
| - | 116586 | 9.4% |
| 1 | 25651 | 2.1% |
| 4 | 19573 | 1.6% |
| 9 | 19453 | 1.6% |
| _ | 19108 | 1.5% |
| . | 15578 | 1.3% |
| 0 | 8132 | 0.7% |
| 7 | 5765 | 0.5% |
| 2 | 5212 | 0.4% |
| Other values (11) | 15447 | 1.2% |
Arabic
| Value | Count | Frequency (%) |
| س | 2 | |
| ف | 1 | |
| ي | 1 | |
| ل | 1 | |
| م | 1 | |
| ك | 1 | |
| ى | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4187821 | |
| Arabic | 8 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| / | 986276 | |
| t | 539889 | |
| o | 313010 | 7.5% |
| a | 299566 | 7.2% |
| u | 248905 | 5.9% |
| b | 239785 | 5.7% |
| y | 235075 | 5.6% |
| e | 137264 | 3.3% |
| - | 116586 | 2.8% |
| i | 108143 | 2.6% |
| Other values (63) | 963322 |
Arabic
| Value | Count | Frequency (%) |
| س | 2 | |
| ف | 1 | |
| ي | 1 | |
| ل | 1 | |
| م | 1 | |
| ك | 1 | |
| ى | 1 |
| Common prefix | / |
|---|---|
| Unique stems | 1474 |
| Unique names | 515 |
| Unique extensions | 23 |
| Unique directories | 1124 |
| Unique anchors | 1 |
| Value | Count | Frequency (%) |
| / | 75523 | 8.4% |
| /yt/about/ | 71036 | 7.9% |
| /analytics/web/ | 14620 | 1.6% |
| /yt/about/tr/ | 14599 | 1.6% |
| /yt/about/vi/ | 13753 | 1.5% |
| /yt/about/es-419/ | 12735 | 1.4% |
| /yt/about/pt-BR/ | 12003 | 1.3% |
| /yt/about/th/ | 11430 | 1.3% |
| /yt/about/ru/ | 11193 | 1.2% |
| /yt/about/es/ | 7092 | 0.8% |
| Other values (1465) | 86957 | 9.6% |
| (Missing) | 572712 |
| Value | Count | Frequency (%) |
| / | 75523 | 8.4% |
| /yt/about/ | 71036 | 7.9% |
| /analytics/web/ | 14620 | 1.6% |
| /yt/about/tr/ | 14599 | 1.6% |
| /yt/about/vi/ | 13753 | 1.5% |
| /yt/about/es-419/ | 12735 | 1.4% |
| /yt/about/pt-BR/ | 12003 | 1.3% |
| /yt/about/th/ | 11430 | 1.3% |
| /yt/about/ru/ | 11193 | 1.2% |
| /yt/about/es/ | 7092 | 0.8% |
| Other values (1464) | 86957 | 9.6% |
| (Missing) | 572712 |
| Value | Count | Frequency (%) |
| 304574 | ||
| using-the-logo.html | 5284 | 0.6% |
| How-To-Visit-the-Googleplex-the-Google-Head-Office-in-Mountain-View.htm | 2056 | 0.2% |
| index.html | 2023 | 0.2% |
| c10b14f9a69ff71b1b7a | 1784 | 0.2% |
| inpage_launch | 1638 | 0.2% |
| alphabet-google-discounts | 1118 | 0.1% |
| 2145 | 1064 | 0.1% |
| Where-can-I-buy-a-stuffed-Go-language-gopher-mascot-online | 872 | 0.1% |
| mobile | 812 | 0.1% |
| Other values (505) | 9716 | 1.1% |
| (Missing) | 572712 |
| Value | Count | Frequency (%) |
| 319771 | ||
| .html | 7848 | 0.9% |
| .htm | 2059 | 0.2% |
| .php | 724 | 0.1% |
| .aspx | 190 | < 0.1% |
| .jhtml | 145 | < 0.1% |
| .jspa | 80 | < 0.1% |
| .jsp | 73 | < 0.1% |
| 15 | < 0.1% | |
| .lai | 8 | < 0.1% |
| Other values (13) | 28 | < 0.1% |
| (Missing) | 572712 |
| Value | Count | Frequency (%) |
| / | 82812 | 9.2% |
| /yt/about | 71408 | 7.9% |
| /analytics/web | 16258 | 1.8% |
| /yt/about/tr | 14665 | 1.6% |
| /yt/about/vi | 13788 | 1.5% |
| /yt/about/es-419 | 12832 | 1.4% |
| /yt/about/pt-BR | 12077 | 1.3% |
| /yt/about/th | 11471 | 1.3% |
| /yt/about/ru | 11294 | 1.2% |
| /yt/about/es | 7143 | 0.8% |
| Other values (1114) | 77193 | 8.5% |
| (Missing) | 572712 |
| Value | Count | Frequency (%) |
| 330941 | ||
| (Missing) | 572712 |
adwordsClickInfo.page
Real number (ℝ)
HIGH CORRELATION  MISSING  SKEWED 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 882193 |
| Missing (%) | 97.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0081081 |
| Minimum | 1 |
|---|---|
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 14 |
| Range | 13 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.17358392 |
|---|---|
| Coefficient of variation (CV) | 0.1721878 |
| Kurtosis | 2188.361 |
| Mean | 1.0081081 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 40.170902 |
| Sum | 21634 |
| Variance | 0.030131376 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 21362 | 2.4% |
| 2 | 73 | < 0.1% |
| 3 | 10 | < 0.1% |
| 5 | 7 | < 0.1% |
| 7 | 3 | < 0.1% |
| 9 | 2 | < 0.1% |
| 4 | 2 | < 0.1% |
| 14 | 1 | < 0.1% |
| (Missing) | 882193 |
| Value | Count | Frequency (%) |
| 1 | 21362 | |
| 2 | 73 | < 0.1% |
| 3 | 10 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 7 | < 0.1% |
| 7 | 3 | < 0.1% |
| 9 | 2 | < 0.1% |
| 14 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 14 | 1 | < 0.1% |
| 9 | 2 | < 0.1% |
| 7 | 3 | < 0.1% |
| 5 | 7 | < 0.1% |
| 4 | 2 | < 0.1% |
| 3 | 10 | < 0.1% |
| 2 | 73 | < 0.1% |
| 1 | 21362 |
adwordsClickInfo.slot
Categorical
HIGH CORRELATION  IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 882193 |
| Missing (%) | 97.6% |
| Memory size | 34.9 MiB |
| Top | |
|---|---|
| RHS | 504 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 64380 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Top |
|---|---|
| 2nd row | Top |
| 3rd row | Top |
| 4th row | Top |
| 5th row | Top |
Common Values
| Value | Count | Frequency (%) |
| Top | 20956 | 2.3% |
| RHS | 504 | 0.1% |
| (Missing) | 882193 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| top | 20956 | |
| rhs | 504 | 2.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 20956 | |
| o | 20956 | |
| p | 20956 | |
| R | 504 | 0.8% |
| H | 504 | 0.8% |
| S | 504 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 41912 | |
| Uppercase Letter | 22468 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 20956 | |
| R | 504 | 2.2% |
| H | 504 | 2.2% |
| S | 504 | 2.2% |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 20956 | |
| p | 20956 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 64380 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| T | 20956 | |
| o | 20956 | |
| p | 20956 | |
| R | 504 | 0.8% |
| H | 504 | 0.8% |
| S | 504 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 64380 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| T | 20956 | |
| o | 20956 | |
| p | 20956 | |
| R | 504 | 0.8% |
| H | 504 | 0.8% |
| S | 504 | 0.8% |
MISSING 
| Distinct | 17774 |
|---|---|
| Distinct (%) | 82.4% |
| Missing | 882092 |
| Missing (%) | 97.6% |
| Memory size | 29.5 MiB |
Length
| Max length | 92 |
|---|---|
| Median length | 91 |
| Mean length | 69.235703 |
| Min length | 26 |
Characters and Unicode
| Total characters | 1492791 |
|---|---|
| Distinct characters | 64 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 15688 ? |
|---|---|
| Unique (%) | 72.8% |
Sample
| 1st row | Cj0KEQjwxqS-BRDRgPLp0q2t0IUBEiQAgfMXRBVDYwnFawcmsrhs02pjO7FXPLhzHyvJFv53h1H4QJ8aAhtw8P8HAQ |
|---|---|
| 2nd row | Cj0KEQjwxqS-BRDRgPLp0q2t0IUBEiQAgfMXRAq0D2zir1iAiqwgFU0lcMGVY6qaqhBTOFSAIW7gM8saAiku8P8HAQ |
| 3rd row | Cj0KEQjwxqS-BRDRgPLp0q2t0IUBEiQAgfMXRMbhgNCALey5pPeCxitqlWsaKLtXW_EC8qRLRreq6OMaApJJ8P8HAQ |
| 4th row | Cj0KEQjwxqS-BRDRgPLp0q2t0IUBEiQAgfMXRBRI7rtb79aCyB-UUNNHh1V712wows-T-MlL9VW-8ZEaAhqd8P8HAQ |
| 5th row | Cj0KEQjwxqS-BRDRgPLp0q2t0IUBEiQAgfMXRDKcQOTkfRji3NxEErk_rDSPqc8VzHFSZnRcZBCoBOgaAgeG8P8HAQ |
| Value | Count | Frequency (%) |
| cj0keqjwmirjbrcrmj_x7kdo-9obeiqauupkmufmpug3zdwyo8gtsjibfd5mphstza9y_9ncri8x97oaaglc8p8haq | 70 | 0.3% |
| cj0keqjw1ee_brd3hk6x993yzeobeiqa5rh_bea562m9tvl_mtnafvtdndqoqrp1rvxmmgwjcx1lafwaaj4o8p8haq | 41 | 0.2% |
| cjh1vbf94m8cfuelgqodyakhgq | 29 | 0.1% |
| cj0keqiaw_debrchnyiq_562gsebeiqa4lcssmb_rwgvppnltzlzj5rgwqx5lk87wc5cjfcqznenzewaaiap8p8haq | 27 | 0.1% |
| cjwkeaiaj7tcbrcp2z22ue-zrj4sjacg7sbejui6ggr6oca-edc2-lx7w1m5ia1c_qnbzwzvtquanxocb5rw_wcb | 24 | 0.1% |
| cn_u9pavhdacfcnahgodtcqajw | 22 | 0.1% |
| cjwkeaiaxkrfbrdm25f60oegtwwsjabgec-z0_dlpcxhm1ztqlr1ywewxu875yaqwupt7pgmgfezthoceezw_wcb | 21 | 0.1% |
| cnhp7nf2ytmcfvlwdqod_iol5a | 20 | 0.1% |
| cjwkeaiavs7cbrc24rao6bgcoiasjabact5dtalfxcossvr2e2aduhx6z6oe0kauvtqkzl-bcvn1-hocnlrw_wcb | 20 | 0.1% |
| cj6xtee6j9acfqqdfgod8tkdnw | 18 | 0.1% |
| Other values (17764) | 21269 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 71957 | 4.8% |
| C | 62703 | 4.2% |
| w | 52857 | 3.5% |
| B | 47608 | 3.2% |
| E | 42671 | 2.9% |
| Q | 42294 | 2.8% |
| j | 40337 | 2.7% |
| K | 32775 | 2.2% |
| o | 31969 | 2.1% |
| R | 30844 | 2.1% |
| Other values (54) | 1036776 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 686721 | |
| Lowercase Letter | 564972 | |
| Decimal Number | 193611 | 13.0% |
| Connector Punctuation | 28864 | 1.9% |
| Dash Punctuation | 18623 | 1.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 71957 | 10.5% |
| C | 62703 | 9.1% |
| B | 47608 | 6.9% |
| E | 42671 | 6.2% |
| Q | 42294 | 6.2% |
| K | 32775 | 4.8% |
| R | 30844 | 4.5% |
| D | 26904 | 3.9% |
| I | 24996 | 3.6% |
| P | 23785 | 3.5% |
| Other values (16) | 280184 |
Lowercase Letter
| Value | Count | Frequency (%) |
| w | 52857 | 9.4% |
| j | 40337 | 7.1% |
| o | 31969 | 5.7% |
| i | 28639 | 5.1% |
| a | 24959 | 4.4% |
| c | 24188 | 4.3% |
| g | 24027 | 4.3% |
| d | 21898 | 3.9% |
| s | 20665 | 3.7% |
| h | 20152 | 3.6% |
| Other values (16) | 275281 |
Decimal Number
| Value | Count | Frequency (%) |
| 8 | 30621 | |
| 0 | 24046 | |
| 9 | 18500 | |
| 4 | 18386 | |
| 7 | 18118 | |
| 6 | 17972 | |
| 3 | 17049 | |
| 2 | 16457 | |
| 5 | 16391 | |
| 1 | 16071 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 28864 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 18623 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1251693 | |
| Common | 241098 | 16.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 71957 | 5.7% |
| C | 62703 | 5.0% |
| w | 52857 | 4.2% |
| B | 47608 | 3.8% |
| E | 42671 | 3.4% |
| Q | 42294 | 3.4% |
| j | 40337 | 3.2% |
| K | 32775 | 2.6% |
| o | 31969 | 2.6% |
| R | 30844 | 2.5% |
| Other values (42) | 795678 |
Common
| Value | Count | Frequency (%) |
| 8 | 30621 | |
| _ | 28864 | |
| 0 | 24046 | |
| - | 18623 | |
| 9 | 18500 | |
| 4 | 18386 | |
| 7 | 18118 | |
| 6 | 17972 | |
| 3 | 17049 | |
| 2 | 16457 | |
| Other values (2) | 32462 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1492791 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 71957 | 4.8% |
| C | 62703 | 4.2% |
| w | 52857 | 3.5% |
| B | 47608 | 3.2% |
| E | 42671 | 2.9% |
| Q | 42294 | 2.8% |
| j | 40337 | 2.7% |
| K | 32775 | 2.2% |
| o | 31969 | 2.1% |
| R | 30844 | 2.1% |
| Other values (54) | 1036776 |
adwordsClickInfo.adNetworkType
Categorical
HIGH CORRELATION  IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 882193 |
| Missing (%) | 97.6% |
| Memory size | 35.1 MiB |
| Google Search | |
|---|---|
| Search partners | 7 |
Length
| Max length | 15 |
|---|---|
| Median length | 13 |
| Mean length | 13.000652 |
| Min length | 13 |
Characters and Unicode
| Total characters | 278994 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Google Search |
|---|---|
| 2nd row | Google Search |
| 3rd row | Google Search |
| 4th row | Google Search |
| 5th row | Google Search |
Common Values
| Value | Count | Frequency (%) |
| Google Search | 21453 | 2.4% |
| Search partners | 7 | < 0.1% |
| (Missing) | 882193 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| search | 21460 | |
| 21453 | ||
| partners | 7 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 42920 | |
| o | 42906 | |
| r | 21474 | |
| a | 21467 | |
| 21460 | ||
| S | 21460 | |
| c | 21460 | |
| h | 21460 | |
| G | 21453 | |
| g | 21453 | |
| Other values (5) | 21481 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 214621 | |
| Uppercase Letter | 42913 | 15.4% |
| Space Separator | 21460 | 7.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 42920 | |
| o | 42906 | |
| r | 21474 | |
| a | 21467 | |
| c | 21460 | |
| h | 21460 | |
| g | 21453 | |
| l | 21453 | |
| p | 7 | < 0.1% |
| t | 7 | < 0.1% |
| Other values (2) | 14 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 21460 | |
| G | 21453 |
Space Separator
| Value | Count | Frequency (%) |
| 21460 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 257534 | |
| Common | 21460 | 7.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 42920 | |
| o | 42906 | |
| r | 21474 | |
| a | 21467 | |
| S | 21460 | |
| c | 21460 | |
| h | 21460 | |
| G | 21453 | |
| g | 21453 | |
| l | 21453 | |
| Other values (4) | 28 | < 0.1% |
Common
| Value | Count | Frequency (%) |
| 21460 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 278994 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 42920 | |
| o | 42906 | |
| r | 21474 | |
| a | 21467 | |
| 21460 | ||
| S | 21460 | |
| c | 21460 | |
| h | 21460 | |
| G | 21453 | |
| g | 21453 | |
| Other values (5) | 21481 |
adContent
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 44 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 892707 |
| Missing (%) | 98.8% |
| Memory size | 34.9 MiB |
| Google Merchandise Collection | |
|---|---|
| Google Online Store | |
| Display Ad created 3/11/14 | |
| Full auto ad IMAGE ONLY | |
| Ad from 12/13/16 | |
| Other values (39) |
Length
| Max length | 43 |
|---|---|
| Median length | 34 |
| Mean length | 25.126622 |
| Min length | 8 |
Characters and Unicode
| Total characters | 275036 |
|---|---|
| Distinct characters | 63 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Full auto ad IMAGE ONLY |
|---|---|
| 2nd row | First Full Auto Template Test Ad |
| 3rd row | {KeyWord:Google Brand Items} |
| 4th row | Full auto ad IMAGE ONLY |
| 5th row | Full auto ad IMAGE ONLY |
Common Values
| Value | Count | Frequency (%) |
| Google Merchandise Collection | 5122 | 0.6% |
| Google Online Store | 1245 | 0.1% |
| Display Ad created 3/11/14 | 967 | 0.1% |
| Full auto ad IMAGE ONLY | 822 | 0.1% |
| Ad from 12/13/16 | 610 | 0.1% |
| Ad from 11/3/16 | 489 | 0.1% |
| Display Ad created 3/11/15 | 392 | < 0.1% |
| {KeyWord:Google Brand Items} | 251 | < 0.1% |
| {KeyWord:Google Merchandise} | 155 | < 0.1% |
| Ad from 11/7/16 | 123 | < 0.1% |
| Other values (34) | 770 | 0.1% |
| (Missing) | 892707 |
Length
| Value | Count | Frequency (%) |
| 6657 | ||
| merchandise | 5368 | |
| collection | 5122 | |
| ad | 3572 | |
| display | 1409 | 3.9% |
| created | 1409 | 3.9% |
| store | 1252 | 3.5% |
| online | 1245 | 3.5% |
| from | 1225 | 3.4% |
| 3/11/14 | 967 | 2.7% |
| Other values (60) | 7620 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 29938 | 10.9% |
| o | 29217 | 10.6% |
| 24900 | 9.1% | |
| l | 22124 | 8.0% |
| n | 13612 | 4.9% |
| i | 13600 | 4.9% |
| c | 12045 | 4.4% |
| d | 11551 | 4.2% |
| a | 10739 | 3.9% |
| r | 10693 | 3.9% |
| Other values (53) | 96617 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 192416 | |
| Uppercase Letter | 35962 | 13.1% |
| Space Separator | 24900 | 9.1% |
| Decimal Number | 14087 | 5.1% |
| Other Punctuation | 6172 | 2.2% |
| Open Punctuation | 677 | 0.2% |
| Close Punctuation | 677 | 0.2% |
| Connector Punctuation | 110 | < 0.1% |
| Dash Punctuation | 35 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 29938 | |
| o | 29217 | |
| l | 22124 | |
| n | 13612 | |
| i | 13600 | |
| c | 12045 | |
| d | 11551 | 6.0% |
| a | 10739 | 5.6% |
| r | 10693 | 5.6% |
| t | 9533 | 5.0% |
| Other values (12) | 29364 |
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 8112 | |
| M | 6221 | |
| C | 5126 | |
| A | 3652 | |
| O | 2096 | 5.8% |
| D | 1482 | 4.1% |
| S | 1400 | 3.9% |
| I | 1083 | 3.0% |
| F | 1031 | 2.9% |
| L | 996 | 2.8% |
| Other values (12) | 4763 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 8015 | |
| 3 | 2458 | 17.4% |
| 6 | 1222 | 8.7% |
| 4 | 1017 | 7.2% |
| 2 | 688 | 4.9% |
| 5 | 433 | 3.1% |
| 7 | 179 | 1.3% |
| 0 | 75 | 0.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 5276 | |
| : | 677 | 11.0% |
| ? | 111 | 1.8% |
| % | 75 | 1.2% |
| ' | 31 | 0.5% |
| ! | 2 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 24900 |
Open Punctuation
| Value | Count | Frequency (%) |
| { | 677 |
Close Punctuation
| Value | Count | Frequency (%) |
| } | 677 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 110 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 35 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 228378 | |
| Common | 46658 | 17.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 29938 | |
| o | 29217 | |
| l | 22124 | 9.7% |
| n | 13612 | 6.0% |
| i | 13600 | 6.0% |
| c | 12045 | 5.3% |
| d | 11551 | 5.1% |
| a | 10739 | 4.7% |
| r | 10693 | 4.7% |
| t | 9533 | 4.2% |
| Other values (34) | 65326 |
Common
| Value | Count | Frequency (%) |
| 24900 | ||
| 1 | 8015 | 17.2% |
| / | 5276 | 11.3% |
| 3 | 2458 | 5.3% |
| 6 | 1222 | 2.6% |
| 4 | 1017 | 2.2% |
| 2 | 688 | 1.5% |
| { | 677 | 1.5% |
| : | 677 | 1.5% |
| } | 677 | 1.5% |
| Other values (9) | 1051 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 275036 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 29938 | 10.9% |
| o | 29217 | 10.6% |
| 24900 | 9.1% | |
| l | 22124 | 8.0% |
| n | 13612 | 4.9% |
| i | 13600 | 4.9% |
| c | 12045 | 4.4% |
| d | 11551 | 4.2% |
| a | 10739 | 3.9% |
| r | 10693 | 3.9% |
| Other values (53) | 96617 |
conversion
Categorical
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.0 MiB |
| 0 | |
|---|---|
| 1 | 11515 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 903653 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 892138 | |
| 1 | 11515 | 1.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 892138 | |
| 1 | 11515 | 1.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 892138 | |
| 1 | 11515 | 1.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 903653 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 892138 | |
| 1 | 11515 | 1.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 903653 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 892138 | |
| 1 | 11515 | 1.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 903653 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 892138 | |
| 1 | 11515 | 1.3% |
| adContent | adwordsClickInfo.adNetworkType | adwordsClickInfo.page | adwordsClickInfo.slot | campaign | channelGrouping | continent | conversion | deviceCategory | hits | isMobile | medium | operatingSystem | pageviews | subContinent | transactionRevenue | visitId | visitNumber | visitStartTime | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| adContent | 1.000 | 0.431 | 0.076 | 0.330 | 0.979 | 0.998 | 0.327 | 0.076 | 0.262 | 0.173 | 0.321 | 0.998 | 0.174 | 0.181 | 0.201 | -0.127 | 0.559 | -0.298 | 0.559 |
| adwordsClickInfo.adNetworkType | 0.431 | 1.000 | -0.001 | 0.108 | 0.336 | 1.000 | 0.000 | 0.000 | 0.000 | -0.021 | 0.000 | 1.000 | 0.000 | -0.021 | 0.000 | NaN | -0.007 | 0.002 | -0.007 |
| adwordsClickInfo.page | 0.076 | -0.001 | 1.000 | 0.186 | 0.005 | 1.000 | 0.000 | 0.000 | 0.004 | -0.032 | 0.013 | 1.000 | 0.000 | -0.032 | 0.000 | NaN | -0.003 | -0.008 | -0.003 |
| adwordsClickInfo.slot | 0.330 | 0.108 | 0.186 | 1.000 | 0.098 | 1.000 | 0.013 | 0.009 | 0.109 | 0.082 | 0.059 | 1.000 | 0.070 | 0.084 | 0.000 | 0.005 | 0.015 | 0.045 | 0.015 |
| campaign | 0.979 | 0.336 | 0.005 | 0.098 | 1.000 | 0.516 | 0.069 | 0.019 | 0.068 | 0.041 | 0.094 | 0.557 | 0.039 | 0.041 | 0.060 | -0.041 | 0.030 | 0.034 | 0.030 |
| channelGrouping | 0.998 | 1.000 | 1.000 | 1.000 | 0.516 | 1.000 | 0.188 | 0.131 | 0.218 | -0.113 | 0.307 | 1.000 | 0.169 | -0.111 | 0.222 | 0.031 | -0.226 | -0.088 | -0.226 |
| continent | 0.327 | 0.000 | 0.000 | 0.013 | 0.069 | 0.188 | 1.000 | 0.109 | 0.063 | -0.226 | 0.069 | 0.131 | 0.157 | -0.227 | 1.000 | 0.002 | -0.011 | -0.165 | -0.011 |
| conversion | 0.076 | 0.000 | 0.000 | 0.009 | 0.019 | 0.131 | 0.109 | 1.000 | 0.045 | 0.196 | 0.045 | 0.035 | 0.089 | 0.199 | 0.123 | NaN | 0.011 | 0.109 | 0.011 |
| deviceCategory | 0.262 | 0.000 | 0.004 | 0.109 | 0.068 | 0.218 | 0.063 | 0.045 | 1.000 | -0.015 | 0.999 | 0.216 | 0.715 | -0.017 | 0.129 | -0.176 | 0.144 | -0.028 | 0.144 |
| hits | 0.173 | -0.021 | -0.032 | 0.082 | 0.041 | -0.113 | -0.226 | 0.196 | -0.015 | 1.000 | 0.024 | 0.007 | 0.016 | 0.992 | 0.022 | 0.295 | -0.000 | 0.115 | -0.000 |
| isMobile | 0.321 | 0.000 | 0.013 | 0.059 | 0.094 | 0.307 | 0.069 | 0.045 | 0.999 | 0.024 | 1.000 | 0.304 | 0.994 | -0.018 | 0.167 | -0.176 | 0.146 | -0.029 | 0.146 |
| medium | 0.998 | 1.000 | 1.000 | 1.000 | 0.557 | 1.000 | 0.131 | 0.035 | 0.216 | 0.007 | 0.304 | 1.000 | 0.145 | -0.072 | 0.169 | 0.034 | -0.198 | -0.053 | -0.198 |
| operatingSystem | 0.174 | 0.000 | 0.000 | 0.070 | 0.039 | 0.169 | 0.157 | 0.089 | 0.715 | 0.016 | 0.994 | 0.145 | 1.000 | -0.068 | 0.116 | -0.067 | 0.001 | -0.074 | 0.001 |
| pageviews | 0.181 | -0.021 | -0.032 | 0.084 | 0.041 | -0.111 | -0.227 | 0.199 | -0.017 | 0.992 | -0.018 | -0.072 | -0.068 | 1.000 | 0.016 | 0.270 | 0.005 | 0.114 | 0.005 |
| subContinent | 0.201 | 0.000 | 0.000 | 0.000 | 0.060 | 0.222 | 1.000 | 0.123 | 0.129 | 0.022 | 0.167 | 0.169 | 0.116 | 0.016 | 1.000 | 0.027 | -0.047 | -0.110 | -0.047 |
| transactionRevenue | -0.127 | NaN | NaN | 0.005 | -0.041 | 0.031 | 0.002 | NaN | -0.176 | 0.295 | -0.176 | 0.034 | -0.067 | 0.270 | 0.027 | 1.000 | -0.069 | 0.218 | -0.069 |
| visitId | 0.559 | -0.007 | -0.003 | 0.015 | 0.030 | -0.226 | -0.011 | 0.011 | 0.144 | -0.000 | 0.146 | -0.198 | 0.001 | 0.005 | -0.047 | -0.069 | 1.000 | 0.041 | 1.000 |
| visitNumber | -0.298 | 0.002 | -0.008 | 0.045 | 0.034 | -0.088 | -0.165 | 0.109 | -0.028 | 0.115 | -0.029 | -0.053 | -0.074 | 0.114 | -0.110 | 0.218 | 0.041 | 1.000 | 0.041 |
| visitStartTime | 0.559 | -0.007 | -0.003 | 0.015 | 0.030 | -0.226 | -0.011 | 0.011 | 0.144 | -0.000 | 0.146 | -0.198 | 0.001 | 0.005 | -0.047 | -0.069 | 1.000 | 0.041 | 1.000 |
| channelGrouping | date | fullVisitorId | sessionId | visitId | visitNumber | visitStartTime | continent | subContinent | country | region | metro | city | networkDomain | browser | operatingSystem | isMobile | deviceCategory | hits | pageviews | transactionRevenue | campaign | source | medium | keyword | referralPath | adwordsClickInfo.page | adwordsClickInfo.slot | adwordsClickInfo.gclId | adwordsClickInfo.adNetworkType | adContent | conversion | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Organic Search | 1970-01-01 00:00:00.020160902 | 1131660440785968503 | 1131660440785968503_1472830385 | 1472830385 | 1 | 1472830385 | Asia | Western Asia | Turkey | Izmir | (not set) | Izmir | ttnet.com.tr | Chrome | Windows | False | desktop | 1 | 1.0 | NaN | (not set) | organic | (not provided) | NaN | NaN | NaN | NaN | NaN | NaN | 0 | |
| 1 | Organic Search | 1970-01-01 00:00:00.020160902 | 377306020877927890 | 377306020877927890_1472880147 | 1472880147 | 1 | 1472880147 | Oceania | Australasia | Australia | not available in demo dataset | not available in demo dataset | not available in demo dataset | dodo.net.au | Firefox | Macintosh | False | desktop | 1 | 1.0 | NaN | (not set) | organic | (not provided) | NaN | NaN | NaN | NaN | NaN | NaN | 0 | |
| 2 | Organic Search | 1970-01-01 00:00:00.020160902 | 3895546263509774583 | 3895546263509774583_1472865386 | 1472865386 | 1 | 1472865386 | Europe | Southern Europe | Spain | Community of Madrid | (not set) | Madrid | unknown.unknown | Chrome | Windows | False | desktop | 1 | 1.0 | NaN | (not set) | organic | (not provided) | NaN | NaN | NaN | NaN | NaN | NaN | 0 | |
| 3 | Organic Search | 1970-01-01 00:00:00.020160902 | 4763447161404445595 | 4763447161404445595_1472881213 | 1472881213 | 1 | 1472881213 | Asia | Southeast Asia | Indonesia | not available in demo dataset | not available in demo dataset | not available in demo dataset | unknown.unknown | UC Browser | Linux | False | desktop | 1 | 1.0 | NaN | (not set) | organic | google + online | NaN | NaN | NaN | NaN | NaN | NaN | 0 | |
| 4 | Organic Search | 1970-01-01 00:00:00.020160902 | 27294437909732085 | 27294437909732085_1472822600 | 1472822600 | 2 | 1472822600 | Europe | Northern Europe | United Kingdom | not available in demo dataset | not available in demo dataset | not available in demo dataset | unknown.unknown | Chrome | Android | True | mobile | 1 | 1.0 | NaN | (not set) | organic | (not provided) | NaN | NaN | NaN | NaN | NaN | NaN | 0 | |
| 5 | Organic Search | 1970-01-01 00:00:00.020160902 | 2938943183656635653 | 2938943183656635653_1472807194 | 1472807194 | 1 | 1472807194 | Europe | Southern Europe | Italy | not available in demo dataset | not available in demo dataset | not available in demo dataset | fastwebnet.it | Chrome | Windows | False | desktop | 1 | 1.0 | NaN | (not set) | organic | (not provided) | NaN | NaN | NaN | NaN | NaN | NaN | 0 | |
| 6 | Organic Search | 1970-01-01 00:00:00.020160902 | 1905672039242460897 | 1905672039242460897_1472817241 | 1472817241 | 1 | 1472817241 | Asia | Southern Asia | Pakistan | not available in demo dataset | not available in demo dataset | not available in demo dataset | unknown.unknown | Chrome | Windows | False | desktop | 1 | 1.0 | NaN | (not set) | organic | (not provided) | NaN | NaN | NaN | NaN | NaN | NaN | 0 | |
| 7 | Organic Search | 1970-01-01 00:00:00.020160902 | 537222803633850821 | 537222803633850821_1472812602 | 1472812602 | 1 | 1472812602 | Oceania | Australasia | Australia | Queensland | (not set) | Brisbane | bigpond.net.au | Chrome | Windows | False | desktop | 1 | 1.0 | NaN | (not set) | organic | (not provided) | NaN | NaN | NaN | NaN | NaN | NaN | 0 | |
| 8 | Organic Search | 1970-01-01 00:00:00.020160902 | 4445454811831400414 | 4445454811831400414_1472805784 | 1472805784 | 1 | 1472805784 | Europe | Western Europe | Austria | not available in demo dataset | not available in demo dataset | not available in demo dataset | spar.at | Internet Explorer | Windows | False | desktop | 1 | 1.0 | NaN | (not set) | organic | (not provided) | NaN | NaN | NaN | NaN | NaN | NaN | 0 | |
| 9 | Organic Search | 1970-01-01 00:00:00.020160902 | 9499785259412240342 | 9499785259412240342_1472812272 | 1472812272 | 1 | 1472812272 | Europe | Western Europe | Netherlands | not available in demo dataset | not available in demo dataset | not available in demo dataset | chello.nl | Firefox | Windows | False | desktop | 1 | 1.0 | NaN | (not set) | organic | (not provided) | NaN | NaN | NaN | NaN | NaN | NaN | 0 |
| channelGrouping | date | fullVisitorId | sessionId | visitId | visitNumber | visitStartTime | continent | subContinent | country | region | metro | city | networkDomain | browser | operatingSystem | isMobile | deviceCategory | hits | pageviews | transactionRevenue | campaign | source | medium | keyword | referralPath | adwordsClickInfo.page | adwordsClickInfo.slot | adwordsClickInfo.gclId | adwordsClickInfo.adNetworkType | adContent | conversion | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 903643 | Social | 1970-01-01 00:00:00.020170104 | 56144239667131330 | 056144239667131330_1483600246 | 1483600246 | 4 | 1483600246 | Americas | Northern America | United States | California | San Francisco-Oakland-San Jose CA | Fremont | (not set) | Chrome | Macintosh | False | desktop | 11 | 10.0 | NaN | (not set) | groups.google.com | referral | NaN | /a/google.com/forum/ | NaN | NaN | NaN | NaN | NaN | 0 |
| 903644 | Social | 1970-01-01 00:00:00.020170104 | 256641390199759052 | 256641390199759052_1483556333 | 1483556333 | 1 | 1483556333 | Americas | Northern America | United States | not available in demo dataset | not available in demo dataset | not available in demo dataset | rr.com | Chrome | iOS | True | tablet | 11 | 7.0 | NaN | (not set) | m.youtube.com | referral | NaN | /watch | NaN | NaN | NaN | NaN | NaN | 0 |
| 903645 | Social | 1970-01-01 00:00:00.020170104 | 2035095632074835075 | 2035095632074835075_1483570454 | 1483570454 | 1 | 1483570454 | Americas | Northern America | United States | New York | New York NY | New York | att.net | Safari (in-app) | iOS | True | mobile | 11 | 8.0 | NaN | (not set) | m.facebook.com | referral | NaN | / | NaN | NaN | NaN | NaN | NaN | 0 |
| 903646 | Social | 1970-01-01 00:00:00.020170104 | 567297396362985009 | 567297396362985009_1483581760 | 1483581760 | 1 | 1483581760 | Oceania | Australasia | Australia | Victoria | (not set) | Melbourne | optusnet.com.au | Chrome | iOS | True | tablet | 15 | 12.0 | NaN | (not set) | youtube.com | referral | NaN | /yt/about/ | NaN | NaN | NaN | NaN | NaN | 0 |
| 903647 | Social | 1970-01-01 00:00:00.020170104 | 2140149974339316233 | 2140149974339316233_1483557808 | 1483557808 | 1 | 1483557808 | Africa | Northern Africa | Egypt | not available in demo dataset | not available in demo dataset | not available in demo dataset | tedata.net | Chrome | Windows | False | desktop | 16 | 11.0 | NaN | (not set) | youtube.com | referral | NaN | /yt/about/ar/ | NaN | NaN | NaN | NaN | NaN | 0 |
| 903648 | Social | 1970-01-01 00:00:00.020170104 | 5123779100307500332 | 5123779100307500332_1483554750 | 1483554750 | 1 | 1483554750 | Americas | Caribbean | Puerto Rico | not available in demo dataset | not available in demo dataset | not available in demo dataset | prtc.net | Chrome | Windows | False | desktop | 17 | 15.0 | NaN | (not set) | youtube.com | referral | NaN | /yt/about/ | NaN | NaN | NaN | NaN | NaN | 0 |
| 903649 | Social | 1970-01-01 00:00:00.020170104 | 7231728964973959842 | 7231728964973959842_1483543798 | 1483543798 | 1 | 1483543798 | Asia | Southern Asia | Sri Lanka | not available in demo dataset | not available in demo dataset | not available in demo dataset | unknown.unknown | Chrome | Android | True | mobile | 18 | 13.0 | NaN | (not set) | youtube.com | referral | NaN | /yt/about/ | NaN | NaN | NaN | NaN | NaN | 0 |
| 903650 | Social | 1970-01-01 00:00:00.020170104 | 5744576632396406899 | 5744576632396406899_1483526434 | 1483526434 | 1 | 1483526434 | Asia | Eastern Asia | South Korea | Seoul | (not set) | Seoul | unknown.unknown | Android Webview | Android | True | mobile | 24 | 21.0 | NaN | (not set) | youtube.com | referral | NaN | /yt/about/ko/ | NaN | NaN | NaN | NaN | NaN | 0 |
| 903651 | Social | 1970-01-01 00:00:00.020170104 | 2709355455991750775 | 2709355455991750775_1483592857 | 1483592857 | 1 | 1483592864 | Asia | Southeast Asia | Indonesia | not available in demo dataset | not available in demo dataset | not available in demo dataset | unknown.unknown | Chrome | Windows | False | desktop | 24 | 22.0 | NaN | (not set) | facebook.com | referral | NaN | /l.php | NaN | NaN | NaN | NaN | NaN | 0 |
| 903652 | Social | 1970-01-01 00:00:00.020170104 | 814900163617805053 | 0814900163617805053_1483574474 | 1483574474 | 1 | 1483574474 | Americas | Central America | Mexico | not available in demo dataset | not available in demo dataset | not available in demo dataset | cybercable.net.mx | Chrome | Android | True | mobile | 31 | 31.0 | NaN | (not set) | youtube.com | referral | NaN | /yt/about/es-419/ | NaN | NaN | NaN | NaN | NaN | 0 |